/*
 Navicat Premium Data Transfer

 Source Server         : .
 Source Server Type    : MySQL
 Source Server Version : 80020
 Source Host           : localhost:3306
 Source Schema         : electricity_meter

 Target Server Type    : MySQL
 Target Server Version : 80020
 File Encoding         : 65001

 Date: 02/05/2022 15:04:41
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for tb_app_user
-- ----------------------------
DROP TABLE IF EXISTS `tb_app_user`;
CREATE TABLE `tb_app_user` (
  `app_user_id` varchar(200) NOT NULL COMMENT 'app端用户主键',
  `user_name` varchar(255) DEFAULT NULL COMMENT '用户名',
  `password` varchar(255) DEFAULT NULL COMMENT '密码',
  `balance` decimal(10,2) DEFAULT NULL COMMENT '账户余额',
  `phone` varchar(11) DEFAULT NULL COMMENT '手机号码',
  `avatar` varchar(255) DEFAULT NULL COMMENT '头像地址',
  `email` varchar(255) DEFAULT NULL COMMENT '邮箱',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `room_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '房间id',
  `use_balance_default` varchar(1) NOT NULL DEFAULT '1' COMMENT '默认使用余额支付',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`app_user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='app端用户表';

-- ----------------------------
-- Records of tb_app_user
-- ----------------------------
BEGIN;
INSERT INTO `tb_app_user` VALUES ('906327614052892672', 'test1', '123', 510.60, '123', '1', '1', '2022-01-06 11:11:59', '2022-03-01 17:22:46', '914269877378744320', '1', NULL);
COMMIT;

-- ----------------------------
-- Table structure for tb_balance
-- ----------------------------
DROP TABLE IF EXISTS `tb_balance`;
CREATE TABLE `tb_balance` (
  `balance_id` varchar(200) NOT NULL COMMENT '充值记录id',
  `balance_amount` decimal(10,2) DEFAULT NULL COMMENT '充值金额',
  `balance_time` datetime DEFAULT NULL COMMENT '充值时间',
  `payment` varchar(1) DEFAULT NULL COMMENT '支付类型',
  `app_user_id` varchar(200) NOT NULL COMMENT 'app端用户id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`balance_id`,`app_user_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='app端用户余额表';

-- ----------------------------
-- Records of tb_balance
-- ----------------------------
BEGIN;
INSERT INTO `tb_balance` VALUES ('948266087621853184', 0.05, '2022-03-01 17:10:53', '1', '906327614052892672', '2022-03-01 17:10:53', '2022-03-01 17:10:53');
INSERT INTO `tb_balance` VALUES ('948266191145664512', 0.50, '2022-03-01 17:11:18', '1', '906327614052892672', '2022-03-01 17:11:18', '2022-03-01 17:11:18');
INSERT INTO `tb_balance` VALUES ('948266505752018944', 100.00, '2022-03-01 17:12:33', '1', '906327614052892672', '2022-03-01 17:12:33', '2022-03-01 17:12:33');
INSERT INTO `tb_balance` VALUES ('948268949106065408', 200.00, '2022-03-01 17:22:15', '1', '906327614052892672', '2022-03-01 17:22:15', '2022-03-01 17:22:15');
INSERT INTO `tb_balance` VALUES ('948268954214727680', 200.00, '2022-03-01 17:22:17', '1', '906327614052892672', '2022-03-01 17:22:17', '2022-03-01 17:22:17');
INSERT INTO `tb_balance` VALUES ('948269076650655744', 10.05, '2022-03-01 17:22:46', '1', '906327614052892672', '2022-03-01 17:22:46', '2022-03-01 17:22:46');
COMMIT;

-- ----------------------------
-- Table structure for tb_bill
-- ----------------------------
DROP TABLE IF EXISTS `tb_bill`;
CREATE TABLE `tb_bill` (
  `bill_id` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '费用单id',
  `paid` int DEFAULT NULL COMMENT '0未缴费，1已缴费',
  `paid_date` datetime DEFAULT NULL COMMENT '缴费时间',
  `balance_id` varchar(200) DEFAULT NULL COMMENT '账户余额id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `equipment_identifier` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '设备id，唯一识别码',
  `app_user_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT 'app端用户id',
  `app_user_phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT 'app端用户手机',
  PRIMARY KEY (`bill_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='费用账单';

-- ----------------------------
-- Records of tb_bill
-- ----------------------------
BEGIN;
INSERT INTO `tb_bill` VALUES ('7f89f8f11b9c47b6ba7c6747e9ea56db', 0, '2022-01-06 09:14:36', '22490be13a1b46a29554467dfd8a30e8', '2021-11-05 23:42:22', '2021-11-05 23:42:22', '2A1123H24', '906327614052892672', '133');
COMMIT;

-- ----------------------------
-- Table structure for tb_building
-- ----------------------------
DROP TABLE IF EXISTS `tb_building`;
CREATE TABLE `tb_building` (
  `building_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '楼栋id',
  `building_name` varchar(255) DEFAULT NULL COMMENT '楼栋名称',
  `is_deleted` int DEFAULT NULL COMMENT '1表示已删除，0表示正常，2表示禁用',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `campus_id` varchar(200) DEFAULT NULL COMMENT '校区id',
  PRIMARY KEY (`building_id`) USING BTREE,
  KEY `FK_CAMPUS_BUILDING` (`campus_id`),
  CONSTRAINT `FK_CAMPUS_BUILDING` FOREIGN KEY (`campus_id`) REFERENCES `tb_campus` (`campus_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='楼栋';

-- ----------------------------
-- Records of tb_building
-- ----------------------------
BEGIN;
INSERT INTO `tb_building` VALUES ('904783914302701569', '学1', 0, '2021-11-01 04:28:15', '2021-11-01 04:28:15', '主校区', '886359318637576192');
INSERT INTO `tb_building` VALUES ('904783914302701570', '学2', 0, '2021-11-01 04:28:15', '2021-11-01 04:28:15', '主校区', '886359318637576192');
INSERT INTO `tb_building` VALUES ('904783914302701571', '学3', 0, '2021-11-01 04:28:15', '2021-11-01 04:28:15', '主校区', '886359318637576192');
INSERT INTO `tb_building` VALUES ('904783914302701572', '学4', 0, '2021-11-01 04:28:15', '2021-11-01 04:28:15', '主校区', '886359318637576192');
INSERT INTO `tb_building` VALUES ('904783914302701573', '学5', 0, '2021-11-01 04:28:15', '2021-11-01 04:28:15', '主校区', '886359318637576192');
INSERT INTO `tb_building` VALUES ('959133970614714368', '广理1号楼', 0, '2022-03-31 16:55:58', '2022-03-31 16:55:58', '广东理工学院', '959130324070039552');
INSERT INTO `tb_building` VALUES ('959133970614714369', '广理2号楼', 0, '2022-03-31 16:55:58', '2022-03-31 16:55:58', '广东理工学院', '959130324070039552');
INSERT INTO `tb_building` VALUES ('959133970614714370', '广理3号楼', 0, '2022-03-31 16:55:58', '2022-03-31 16:55:58', '广东理工学院', '959130324070039552');
INSERT INTO `tb_building` VALUES ('959133970614714371', '广理4号楼', 0, '2022-03-31 16:55:58', '2022-03-31 16:55:58', '广东理工学院', '959130324070039552');
INSERT INTO `tb_building` VALUES ('959133970614714372', '广理5号楼', 0, '2022-03-31 16:55:58', '2022-03-31 16:55:58', '广东理工学院', '959130324070039552');
INSERT INTO `tb_building` VALUES ('959133970614714373', '广理6号楼', 0, '2022-03-31 16:55:58', '2022-03-31 16:55:58', '广东理工学院', '959130324070039552');
INSERT INTO `tb_building` VALUES ('959133970614714374', '广理7号楼', 0, '2022-03-31 16:55:58', '2022-03-31 16:55:58', '广东理工学院', '959130324070039552');
INSERT INTO `tb_building` VALUES ('959133970614714375', '广理8号楼', 0, '2022-03-31 16:55:58', '2022-03-31 16:55:58', '广东理工学院', '959130324070039552');
INSERT INTO `tb_building` VALUES ('959134190484324352', '龙山中学1号楼', 0, '2022-03-31 16:56:51', '2022-03-31 16:56:51', '龙山中学', '959127491170009088');
INSERT INTO `tb_building` VALUES ('959134190484324353', '龙山中学2号楼', 0, '2022-03-31 16:56:51', '2022-03-31 16:56:51', '龙山中学', '959127491170009088');
INSERT INTO `tb_building` VALUES ('959134190484324354', '龙山中学3号楼', 0, '2022-03-31 16:56:51', '2022-03-31 16:56:51', '龙山中学', '959127491170009088');
INSERT INTO `tb_building` VALUES ('959134190484324355', '龙山中学4号楼', 0, '2022-03-31 16:56:51', '2022-03-31 16:56:51', '龙山中学', '959127491170009088');
INSERT INTO `tb_building` VALUES ('970691118645641216', '步校区，学1', 0, '2022-05-02 14:19:57', '2022-05-02 14:19:57', '寮步校区，学1', '907362978435694592');
INSERT INTO `tb_building` VALUES ('970691204876337152', '步校区，学2', 0, '2022-05-02 14:20:18', '2022-05-02 14:20:18', '寮步校区，学2', '907362978435694592');
COMMIT;

-- ----------------------------
-- Table structure for tb_campus
-- ----------------------------
DROP TABLE IF EXISTS `tb_campus`;
CREATE TABLE `tb_campus` (
  `campus_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '校区id',
  `school_name` varchar(255) DEFAULT NULL COMMENT '学校名称',
  `campus_name` varchar(255) DEFAULT NULL COMMENT '校区名称',
  `province_city_area` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '校区所在省市区',
  `campus_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '校区地址',
  `contact_person` varchar(255) DEFAULT NULL COMMENT '联系人',
  `phone` varchar(20) DEFAULT NULL COMMENT '手机',
  `is_deleted` int DEFAULT NULL COMMENT '1表示已删除，0表示正常，2表示禁用',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `provider_id` varchar(255) DEFAULT NULL COMMENT '服务商id',
  `fax` varchar(255) DEFAULT NULL COMMENT '传真',
  `email` varchar(255) DEFAULT NULL COMMENT '邮箱',
  `logo` varchar(255) DEFAULT NULL COMMENT '校区logo',
  PRIMARY KEY (`campus_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='校区';

-- ----------------------------
-- Records of tb_campus
-- ----------------------------
BEGIN;
INSERT INTO `tb_campus` VALUES ('886359318637576192', '东莞城市学院', '主校区', '广东省, 东莞市, 寮步镇', '文昌路1号', '林老师', '12351', 0, '2021-09-11 21:15:29', '2021-09-12 17:24:27', '1', '123456', 'lin@163.com', 'https://bkimg.cdn.bcebos.com/pic/9c16fdfaaf51f3deaf28f88b96eef01f3b297942?x-bce-process=image/resize,m_lfit,w_268,limit_1/format,f_jpg');
INSERT INTO `tb_campus` VALUES ('907362978435694592', '东莞城市学院', '寮步校区', '广东省, 东莞市, 寮步镇', '文昌路10号', '万先生', '13782951332', 0, '2021-11-08 20:16:32', '2021-11-08 20:16:32', '898617681375133696', '123454', '12311@163.com', 'https://bkimg.cdn.bcebos.com/pic/9c16fdfaaf51f3deaf28f88b96eef01f3b297942?x-bce-process=image/resize,m_lfit,w_268,limit_1/format,f_jpg');
INSERT INTO `tb_campus` VALUES ('958058530366029824', '测试', '南校区', '广东省,河源市,市辖区', '人民中路', '张三', '13580011021', 1, '2022-03-28 17:42:34', '2022-03-28 17:42:34', '903953808948723712', '0755-8258555', '135@163.com', 'url');
INSERT INTO `tb_campus` VALUES ('959127491170009088', '龙山中学', '东海校区', '广东省,汕尾市,陆丰市', '东海镇马街1号', '万仙山', '13588812345', 0, '2022-03-31 16:37:59', '2022-03-31 16:37:59', '903953808948723712', '0660-82588555', '12345@163.com', 'url');
INSERT INTO `tb_campus` VALUES ('959130324070039552', '广东理工学院', '广东理工学院高要校区', '广东省,肇庆市,高要区', '广东省肇庆市高要区祈福大道广东理工学院', '张三先生', '13629543132', 0, '2022-03-31 18:23:24', '2022-03-31 18:23:24', '959153970117345280', '0758-8387888', '1362954313@163.com', 'url');
COMMIT;

-- ----------------------------
-- Table structure for tb_equipment_management
-- ----------------------------
DROP TABLE IF EXISTS `tb_equipment_management`;
CREATE TABLE `tb_equipment_management` (
  `equipment_identifier` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '设备id，识别码，标识符',
  `equipment_model_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '设备型号',
  `equipment_status` int DEFAULT NULL COMMENT '0表示离线，1表示在线，2表示报警',
  `is_enable` int DEFAULT NULL COMMENT '1表示禁用，0表示未禁用',
  `degree` decimal(10,0) DEFAULT NULL COMMENT '电量数',
  `shut_down` int DEFAULT NULL COMMENT '1表示已关机，0表示开机',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`equipment_identifier`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='设备管理';

-- ----------------------------
-- Records of tb_equipment_management
-- ----------------------------
BEGIN;
INSERT INTO `tb_equipment_management` VALUES ('1h2481jf152fg', '905474437015404544', 1, 0, 0, 1, '2021-11-27 21:42:05', '2021-11-27 21:42:05');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H100', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H23', '905474437015404544', 1, 0, 0, 0, '2021-12-31 19:21:11', '2021-12-31 19:21:11');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H24', '905474437015404544', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H25', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H26', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H27', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H28', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H29', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H30', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H31', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H32', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H33', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H34', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H35', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H36', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H37', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H38', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H39', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H40', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H41', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H42', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H43', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H44', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H45', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H46', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H47', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H48', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H49', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H50', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H51', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H52', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H53', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H54', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H55', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H56', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H57', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H58', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H59', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H60', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H61', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H62', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H63', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H64', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H65', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H66', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H67', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H68', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H69', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H70', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H71', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H72', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H73', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H74', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H75', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H76', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H77', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H78', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H79', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H80', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H81', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H82', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H83', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H84', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H85', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H86', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H87', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H88', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H89', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H90', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H91', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H92', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H93', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H94', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H95', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H96', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H97', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H98', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123H99', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I1', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I10', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I100', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I101', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I102', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I103', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I104', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I105', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I106', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I107', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I108', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I109', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I11', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I110', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I111', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I112', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I113', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I114', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I115', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I116', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I117', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I118', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I119', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I12', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I120', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I121', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I122', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I123', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I124', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I125', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I126', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I127', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I128', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I129', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I13', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I130', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I131', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I132', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I133', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I134', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I135', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I136', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I137', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I138', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I139', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I14', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I140', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I141', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I142', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I143', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I144', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I145', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I146', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I147', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I148', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I149', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I15', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I150', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I151', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I152', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I153', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I154', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I155', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I156', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I157', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I158', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I159', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I16', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I160', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I161', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I162', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I163', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I164', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I165', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I166', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I167', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I168', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I169', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I17', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I170', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I171', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I172', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I173', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I174', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I175', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I176', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I177', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I178', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I179', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I18', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I180', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I181', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I182', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I183', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I184', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I185', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I186', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I187', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I188', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I189', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I19', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I190', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I191', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I192', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I193', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I194', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I195', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I196', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I197', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I198', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I199', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I2', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I20', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I200', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I201', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I202', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I203', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I204', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I205', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I206', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I207', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I208', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I209', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I21', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I210', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I211', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I212', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I213', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I214', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I215', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I216', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I217', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I218', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I219', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I22', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I220', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I221', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I222', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I223', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I224', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I225', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I226', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I227', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I228', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I229', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I23', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I230', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I231', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I232', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I233', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I234', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I235', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I236', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I237', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I238', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I239', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I24', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I240', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I241', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I242', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I243', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I244', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I245', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I246', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I247', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I248', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I249', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I25', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I250', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I251', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I252', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I253', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I254', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I255', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I256', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I257', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I258', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I259', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I26', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I260', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I261', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I262', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I263', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I264', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I265', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I266', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I267', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I268', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I269', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I27', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I270', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I271', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I272', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I273', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I274', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I275', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I276', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I277', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I278', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I279', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I28', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I280', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I281', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I282', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I283', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I284', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I285', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I286', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I287', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I288', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I289', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I29', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I290', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I291', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I292', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I293', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I294', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I295', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I296', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I297', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I298', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I299', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I3', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I30', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I300', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I301', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I302', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I303', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I304', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I305', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I306', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I307', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I308', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I309', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I31', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I310', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I311', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I312', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I313', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I314', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I315', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I316', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I317', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I318', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I319', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I32', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I320', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I321', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I322', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I323', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I324', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I325', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I326', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I327', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I328', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I329', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I33', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I330', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I331', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I332', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I333', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I334', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I335', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I336', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I337', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I338', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I339', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I34', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I340', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I341', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I342', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I343', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I344', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I345', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I346', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I347', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I348', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I349', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I35', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I350', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I351', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I352', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I353', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I354', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I355', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I356', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I357', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I358', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I359', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I36', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I360', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I361', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I362', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I363', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I364', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I365', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I366', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I367', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I368', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I369', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I37', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I370', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I371', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I372', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I373', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I374', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I375', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I376', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I377', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I378', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I379', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I38', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I380', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I381', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I382', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I383', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I384', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I385', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I386', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I387', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I388', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I389', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I39', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I390', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I391', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I392', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I393', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I394', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I395', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I396', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I397', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I398', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I399', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I4', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I40', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I400', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I41', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I42', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I43', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I44', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I45', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I46', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I47', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I48', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I49', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I5', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I50', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I51', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I52', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I53', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I54', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I55', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I56', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I57', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I58', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I59', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I6', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I60', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I61', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I62', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I63', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I64', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I65', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I66', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I67', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I68', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I69', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I7', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I70', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I71', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I72', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I73', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I74', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I75', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I76', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I77', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I78', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I79', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I8', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I80', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I81', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I82', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I83', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I84', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I85', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I86', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I87', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I88', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I89', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I9', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I90', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I91', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I92', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I93', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I94', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I95', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I96', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I97', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I98', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123I99', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J1', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J10', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J11', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J12', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J13', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J14', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J15', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J16', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J17', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J18', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J19', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J2', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J20', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J21', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J22', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J23', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J24', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J25', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J26', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J27', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J28', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J29', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J3', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J30', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J31', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J32', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J33', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J34', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J35', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J36', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J37', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J38', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J39', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J4', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J40', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J41', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J42', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J43', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J44', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J45', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J46', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J47', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J48', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J49', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J5', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J50', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J51', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J52', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J53', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J54', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J55', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J56', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J57', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J58', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J59', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J6', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J60', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J61', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J7', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J8', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2A1123J9', '962011710841946112', 1, 0, 0, 0, '2021-12-31 19:21:39', '2021-12-31 19:21:39');
INSERT INTO `tb_equipment_management` VALUES ('2a2s23', NULL, 1, 0, 0, 0, '2022-05-02 14:23:15', '2022-05-02 14:23:15');
INSERT INTO `tb_equipment_management` VALUES ('2a2s24', NULL, 1, 0, 0, 0, '2022-05-02 14:23:48', '2022-05-02 14:23:48');
INSERT INTO `tb_equipment_management` VALUES ('2a2s25', NULL, 1, 0, 0, 0, '2022-05-02 14:24:13', '2022-05-02 14:24:13');
INSERT INTO `tb_equipment_management` VALUES ('2a2s26', NULL, 1, 0, 0, 0, '2022-05-02 14:24:25', '2022-05-02 14:24:25');
COMMIT;

-- ----------------------------
-- Table structure for tb_equipment_model
-- ----------------------------
DROP TABLE IF EXISTS `tb_equipment_model`;
CREATE TABLE `tb_equipment_model` (
  `equipment_model_id` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键，仅删改查使用',
  `equipment_model` varchar(255) DEFAULT NULL COMMENT '设备具体型号',
  `provider_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '外键，组织服务商id',
  `equipment_number` int DEFAULT NULL COMMENT '设备数量',
  `installed_number` int DEFAULT NULL COMMENT '安装数量',
  `equipment_status` int DEFAULT NULL COMMENT '0表示正常，1表示禁用',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`equipment_model_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='设备型号';

-- ----------------------------
-- Records of tb_equipment_model
-- ----------------------------
BEGIN;
INSERT INTO `tb_equipment_model` VALUES ('905474437015404544', 'ASD203423', '1', 100, 75, 0, '2021-11-03 02:12:09', '2022-05-02 14:24:25');
INSERT INTO `tb_equipment_model` VALUES ('962011710841946112', 'ASD203424', '898878048911228928', 500, 500, 0, '2022-04-08 15:31:05', '2022-04-08 15:31:05');
COMMIT;

-- ----------------------------
-- Table structure for tb_error_log
-- ----------------------------
DROP TABLE IF EXISTS `tb_error_log`;
CREATE TABLE `tb_error_log` (
  `error_id` varchar(200) NOT NULL COMMENT '错误日志主键',
  `error_code` varchar(30) DEFAULT NULL COMMENT '错误码',
  `error_description` varchar(255) DEFAULT NULL COMMENT '错误描述',
  `repaired` int DEFAULT NULL COMMENT '0表示待维修，1表示正常，2表示维修中',
  `report_time` datetime DEFAULT NULL COMMENT '上报时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `equipment_identifier` varchar(200) DEFAULT NULL COMMENT '设备id',
  PRIMARY KEY (`error_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='设备错误日志';

-- ----------------------------
-- Records of tb_error_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for tb_menu
-- ----------------------------
DROP TABLE IF EXISTS `tb_menu`;
CREATE TABLE `tb_menu` (
  `menu_id` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'id',
  `menu_name` varchar(255) DEFAULT NULL COMMENT '菜单名称',
  `level` int DEFAULT NULL COMMENT '级别，1表示一级标题，2表示二级标题，以此类推',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `parent_id` varchar(200) DEFAULT NULL COMMENT '父级id',
  `path` varchar(255) DEFAULT NULL COMMENT '路径',
  PRIMARY KEY (`menu_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='web端用户菜单导航';

-- ----------------------------
-- Records of tb_menu
-- ----------------------------
BEGIN;
INSERT INTO `tb_menu` VALUES ('899060501613379584', '首页', 1, '2021-10-16 22:25:58', '2021-10-16 22:26:00', '0', '/index');
INSERT INTO `tb_menu` VALUES ('899060501613379585', '学校管理', 1, '2021-10-16 22:26:42', '2021-10-16 22:26:44', '0', '/school');
INSERT INTO `tb_menu` VALUES ('899060501613379586', '校区管理', 2, '2021-10-16 22:27:12', '2021-10-16 22:27:14', '899060501613379585', '/campusManage');
INSERT INTO `tb_menu` VALUES ('899060501613379587', '楼栋管理', 2, '2021-10-16 22:27:46', '2021-10-16 22:27:48', '899060501613379585', '/buildingManage');
INSERT INTO `tb_menu` VALUES ('899060501613379588', '房间管理', 2, '2021-10-16 22:28:36', '2021-10-16 22:28:37', '899060501613379585', '/roomManage');
INSERT INTO `tb_menu` VALUES ('899060501613379589', '用电管理', 1, '2021-10-16 22:29:11', '2021-10-16 22:29:13', '0', '/electricity');
INSERT INTO `tb_menu` VALUES ('899060501613379590', '缴费详细', 2, '2021-10-16 22:29:48', '2021-10-16 22:29:50', '899060501613379589', '/payDetail');
INSERT INTO `tb_menu` VALUES ('899060501613379591', '用电详细', 2, '2021-10-16 22:30:30', '2021-10-16 22:30:31', '899060501613379589', '/electricityManage');
INSERT INTO `tb_menu` VALUES ('899060501613379592', '充值管理', 2, '2021-10-16 22:30:54', '2021-10-16 22:30:55', '899060501613379589', '/payInManage');
INSERT INTO `tb_menu` VALUES ('899060501613379593', '设备管理', 1, '2021-10-16 22:31:17', '2021-10-16 22:31:18', '0', '/equipment');
INSERT INTO `tb_menu` VALUES ('899060501613379594', '设备型号管理', 2, '2021-10-16 22:31:59', '2021-10-16 22:32:01', '899060501613379593', '/equipModelManage');
INSERT INTO `tb_menu` VALUES ('899060501613379595', '设备管理', 2, '2021-10-16 22:32:32', '2021-10-16 22:32:34', '899060501613379593', '/equipmentManage');
INSERT INTO `tb_menu` VALUES ('899060501613379596', '集控管理', 2, '2021-10-16 22:33:00', '2021-10-16 22:33:01', '899060501613379593', '/centerManage');
INSERT INTO `tb_menu` VALUES ('899060501613379597', '设备报警日志', 2, '2021-10-16 22:33:23', '2021-10-16 22:33:25', '899060501613379593', '/equipErrorLog');
INSERT INTO `tb_menu` VALUES ('899060501613379598', '系统管理', 1, '2021-10-16 22:34:02', '2021-10-16 22:34:04', '0', '/systemManage');
INSERT INTO `tb_menu` VALUES ('899060501613379599', '用户管理', 2, '2021-10-16 22:34:30', '2021-10-16 22:34:32', '899060501613379598', '/userManage');
INSERT INTO `tb_menu` VALUES ('899060501613379600', '角色管理', 2, '2021-10-16 22:35:02', '2021-10-16 22:35:04', '899060501613379598', '/roleManage');
INSERT INTO `tb_menu` VALUES ('899060501613379601', '组织管理', 2, '2021-10-16 22:35:27', '2021-10-16 22:35:29', '899060501613379598', '/organizationManage');
INSERT INTO `tb_menu` VALUES ('899060501617573888', '账户管理', 1, '2021-10-16 22:36:07', '2022-10-16 22:36:10', '0', '/accountManage');
INSERT INTO `tb_menu` VALUES ('899060501617573889', '个人资料', 2, '2021-10-16 22:37:03', '2021-10-16 22:37:05', '899060501617573888', '/userInfo');
INSERT INTO `tb_menu` VALUES ('899060501617573890', '修改密码', 2, '2021-10-16 22:37:30', '2021-10-16 22:37:44', '899060501617573888', '/changePw');
COMMIT;

-- ----------------------------
-- Table structure for tb_provider
-- ----------------------------
DROP TABLE IF EXISTS `tb_provider`;
CREATE TABLE `tb_provider` (
  `provider_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '服务商id',
  `province` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '服务商所在省',
  `city` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '服务商所在市',
  `area` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '服务商所在区',
  `provider_address` varchar(255) DEFAULT NULL COMMENT '服务商地址',
  `provider_name` varchar(255) DEFAULT NULL COMMENT '服务商名',
  `contact_person` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '联系人',
  `phone` varchar(50) DEFAULT NULL COMMENT '手机',
  `email` varchar(255) DEFAULT NULL COMMENT '邮箱地址',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `provider_status` int DEFAULT NULL COMMENT '1表示已删除，0表示正常，2表示禁用',
  PRIMARY KEY (`provider_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='属服务商，组织';

-- ----------------------------
-- Records of tb_provider
-- ----------------------------
BEGIN;
INSERT INTO `tb_provider` VALUES ('1', '广东省', '东莞市', '寮步镇', '文昌路1号', '寮步镇服务商', '林先生', '12345677890', '1234556@qq.com', '又三年', '2021-09-11 19:15:08', '2021-09-11 19:15:10', 0);
INSERT INTO `tb_provider` VALUES ('898617681375133696', '广东省', '汕头市', '潮阳区', '人民路', '潮阳区服务商', '林先生', '13514239910', '12@qq.com', NULL, '2021-10-15 17:05:51', '2021-10-15 17:05:51', 0);
INSERT INTO `tb_provider` VALUES ('898872697033850880', '*', '北京市', '东城区', '东城区南', '东城区服务商', '王先生', '13587243315', '123@qq.com', NULL, '2021-10-16 09:59:11', '2021-10-16 09:59:11', 0);
INSERT INTO `tb_provider` VALUES ('898878048911228928', '广东省', '东莞市', '南城', '南城街道', '南城服务商', '吴小姐', '13652436789', '13652436789@163.com', NULL, '2021-10-16 10:20:27', '2021-10-16 10:20:27', 0);
INSERT INTO `tb_provider` VALUES ('898881404983574528', '*', '北京市', '西城区', '西城区服务商', '西城区服务商', '李先生', '13582334567', '13582334567@163.com', NULL, '2021-10-16 10:33:47', '2021-10-16 10:33:47', 0);
INSERT INTO `tb_provider` VALUES ('903953808948723712', '广东省', '惠州市', '惠城区', '人民路202号', '惠城区服务商', '何先生', '13584351180', '12138@163.com', NULL, '2021-10-30 02:29:43', '2021-10-30 02:29:43', 0);
INSERT INTO `tb_provider` VALUES ('959153970117345280', '广东省', '肇庆市', '高要区', '321国道西200米', '高要区服务商', '李红', '13452257700', '13452257700@163.com', NULL, '2022-03-31 18:15:27', '2022-03-31 18:15:27', 0);
COMMIT;

-- ----------------------------
-- Table structure for tb_recharge_detail
-- ----------------------------
DROP TABLE IF EXISTS `tb_recharge_detail`;
CREATE TABLE `tb_recharge_detail` (
  `id` varchar(200) NOT NULL COMMENT '充值明细主键',
  `appuser_id` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT 'app端用户id',
  `recharge_model` int DEFAULT NULL COMMENT '1表示线下支付，2表示微信支付',
  `recharge_amount` decimal(10,0) DEFAULT NULL COMMENT '充值金额',
  `create_time` datetime DEFAULT NULL COMMENT '创建\\充值时间',
  `appuser_phone` varchar(255) DEFAULT NULL COMMENT 'app用户手机',
  PRIMARY KEY (`id`),
  KEY `balacne_detail_userId` (`appuser_id`),
  CONSTRAINT `balacne_detail_userId` FOREIGN KEY (`appuser_id`) REFERENCES `tb_web_user` (`web_user_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='app用户充值明细';

-- ----------------------------
-- Records of tb_recharge_detail
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for tb_role
-- ----------------------------
DROP TABLE IF EXISTS `tb_role`;
CREATE TABLE `tb_role` (
  `role_id` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '角色表主键',
  `role_name` varchar(200) NOT NULL COMMENT '角色名称',
  `role_description` varchar(255) DEFAULT NULL COMMENT '角色描述',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `update_time` datetime DEFAULT NULL COMMENT '更新日期',
  `is_deleted` int DEFAULT NULL COMMENT '1表示已删除，0表示正常，2表示禁用',
  PRIMARY KEY (`role_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色表';

-- ----------------------------
-- Records of tb_role
-- ----------------------------
BEGIN;
INSERT INTO `tb_role` VALUES ('12314', '1231', '12312', '2021-10-29 21:42:20', '2021-10-29 21:42:22', 1);
INSERT INTO `tb_role` VALUES ('899080020255834112', 'admin', '管理员', '2021-10-16 23:43:01', '2021-10-16 23:43:01', 1);
INSERT INTO `tb_role` VALUES ('899218474281205760', '安装工', '安装工', '2021-10-16 16:53:11', '2021-10-29 14:13:06', 1);
COMMIT;

-- ----------------------------
-- Table structure for tb_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `tb_role_menu`;
CREATE TABLE `tb_role_menu` (
  `id` varchar(200) NOT NULL COMMENT 'id',
  `menu_id` varchar(200) DEFAULT NULL COMMENT '菜单id',
  `role_id` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '角色id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `role_menu_menuId` (`menu_id`),
  KEY `role_menu_roleId` (`role_id`),
  CONSTRAINT `role_menu_menuId` FOREIGN KEY (`menu_id`) REFERENCES `tb_menu` (`menu_id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT `role_menu_roleId` FOREIGN KEY (`role_id`) REFERENCES `tb_role` (`role_id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色与菜单的关系';

-- ----------------------------
-- Records of tb_role_menu
-- ----------------------------
BEGIN;
INSERT INTO `tb_role_menu` VALUES ('899080020452966400', '899060501613379584', '899080020255834112', '2021-10-16 23:43:01', '2021-10-16 23:43:01');
INSERT INTO `tb_role_menu` VALUES ('899080020482326528', '899060501613379585', '899080020255834112', '2021-10-16 23:43:01', '2021-10-16 23:43:01');
INSERT INTO `tb_role_menu` VALUES ('899080020578795520', '899060501613379586', '899080020255834112', '2021-10-16 23:43:01', '2021-10-16 23:43:01');
INSERT INTO `tb_role_menu` VALUES ('899080020595572736', '899060501613379587', '899080020255834112', '2021-10-16 23:43:01', '2021-10-16 23:43:01');
INSERT INTO `tb_role_menu` VALUES ('899080020608155648', '899060501613379588', '899080020255834112', '2021-10-16 23:43:01', '2021-10-16 23:43:01');
INSERT INTO `tb_role_menu` VALUES ('899080020624932864', '899060501613379589', '899080020255834112', '2021-10-16 23:43:01', '2021-10-16 23:43:01');
INSERT INTO `tb_role_menu` VALUES ('899080020637515776', '899060501613379590', '899080020255834112', '2021-10-16 23:43:01', '2021-10-16 23:43:01');
INSERT INTO `tb_role_menu` VALUES ('899080020658487296', '899060501613379591', '899080020255834112', '2021-10-16 23:43:01', '2021-10-16 23:43:01');
INSERT INTO `tb_role_menu` VALUES ('899080020671070208', '899060501613379592', '899080020255834112', '2021-10-16 23:43:01', '2021-10-16 23:43:01');
INSERT INTO `tb_role_menu` VALUES ('899080020679458816', '899060501613379593', '899080020255834112', '2021-10-16 23:43:01', '2021-10-16 23:43:01');
INSERT INTO `tb_role_menu` VALUES ('899080020687847424', '899060501613379594', '899080020255834112', '2021-10-16 23:43:01', '2021-10-16 23:43:01');
INSERT INTO `tb_role_menu` VALUES ('899080020700430336', '899060501613379595', '899080020255834112', '2021-10-16 23:43:01', '2021-10-16 23:43:01');
INSERT INTO `tb_role_menu` VALUES ('899080020713013248', '899060501613379596', '899080020255834112', '2021-10-16 23:43:01', '2021-10-16 23:43:01');
INSERT INTO `tb_role_menu` VALUES ('899080020733984768', '899060501613379597', '899080020255834112', '2021-10-16 23:43:01', '2021-10-16 23:43:01');
INSERT INTO `tb_role_menu` VALUES ('899080020754956288', '899060501613379598', '899080020255834112', '2021-10-16 23:43:01', '2021-10-16 23:43:01');
INSERT INTO `tb_role_menu` VALUES ('899080020834648064', '899060501613379599', '899080020255834112', '2021-10-16 23:43:01', '2021-10-16 23:43:01');
INSERT INTO `tb_role_menu` VALUES ('899080020847230976', '899060501613379600', '899080020255834112', '2021-10-16 23:43:01', '2021-10-16 23:43:01');
INSERT INTO `tb_role_menu` VALUES ('899080020864008192', '899060501613379601', '899080020255834112', '2021-10-16 23:43:01', '2021-10-16 23:43:01');
INSERT INTO `tb_role_menu` VALUES ('899080020872396800', '899060501617573888', '899080020255834112', '2021-10-16 23:43:01', '2021-10-16 23:43:01');
INSERT INTO `tb_role_menu` VALUES ('899080020880785408', '899060501617573889', '899080020255834112', '2021-10-16 23:43:01', '2021-10-16 23:43:01');
INSERT INTO `tb_role_menu` VALUES ('899080020889174016', '899060501617573890', '899080020255834112', '2021-10-16 23:43:01', '2021-10-16 23:43:01');
INSERT INTO `tb_role_menu` VALUES ('903768432606969856', '899060501613379584', '899218474281205760', '2021-10-29 14:13:06', '2021-10-29 14:13:06');
INSERT INTO `tb_role_menu` VALUES ('903768432674078720', '899060501613379593', '899218474281205760', '2021-10-29 14:13:06', '2021-10-29 14:13:06');
INSERT INTO `tb_role_menu` VALUES ('903768432695050240', '899060501613379594', '899218474281205760', '2021-10-29 14:13:06', '2021-10-29 14:13:06');
INSERT INTO `tb_role_menu` VALUES ('903768432720216064', '899060501613379595', '899218474281205760', '2021-10-29 14:13:06', '2021-10-29 14:13:06');
INSERT INTO `tb_role_menu` VALUES ('903768432812490752', '899060501613379597', '899218474281205760', '2021-10-29 14:13:06', '2021-10-29 14:13:06');
INSERT INTO `tb_role_menu` VALUES ('903768432833462272', '899060501617573888', '899218474281205760', '2021-10-29 14:13:06', '2021-10-29 14:13:06');
INSERT INTO `tb_role_menu` VALUES ('903768432854433792', '899060501617573889', '899218474281205760', '2021-10-29 14:13:06', '2021-10-29 14:13:06');
INSERT INTO `tb_role_menu` VALUES ('903768432896376832', '899060501617573890', '899218474281205760', '2021-10-29 14:13:06', '2021-10-29 14:13:06');
COMMIT;

-- ----------------------------
-- Table structure for tb_room
-- ----------------------------
DROP TABLE IF EXISTS `tb_room`;
CREATE TABLE `tb_room` (
  `room_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '房间id',
  `room_number` varchar(150) DEFAULT NULL COMMENT '房间号',
  `status` int DEFAULT NULL COMMENT '0闲置，1使用',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `equipment_identifier` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '设备唯一识别码',
  `building_id` varchar(200) DEFAULT NULL COMMENT '楼栋id',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`room_id`) USING BTREE,
  KEY `FK_BUILDING_ROOM` (`building_id`),
  CONSTRAINT `FK_BUILDING_ROOM` FOREIGN KEY (`building_id`) REFERENCES `tb_building` (`building_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='房间表';

-- ----------------------------
-- Records of tb_room
-- ----------------------------
BEGIN;
INSERT INTO `tb_room` VALUES ('959136569027985408', '101', 0, '2022-03-31 17:06:18', NULL, '2A1123I334', '959134190484324352', '101');
INSERT INTO `tb_room` VALUES ('959136569053151232', '102', 0, '2022-03-31 17:06:18', NULL, '2A1123I335', '959134190484324352', '102');
INSERT INTO `tb_room` VALUES ('959136569053151233', '103', 0, '2022-03-31 17:06:18', NULL, '2A1123I336', '959134190484324352', '103');
INSERT INTO `tb_room` VALUES ('959136569053151234', '104', 0, '2022-03-31 17:06:18', NULL, '2A1123I337', '959134190484324352', '104');
INSERT INTO `tb_room` VALUES ('959136569053151235', '105', 0, '2022-03-31 17:06:18', NULL, '2A1123I338', '959134190484324352', '105');
INSERT INTO `tb_room` VALUES ('959136569053151236', '106', 0, '2022-03-31 17:06:18', NULL, '2A1123I339', '959134190484324352', '106');
INSERT INTO `tb_room` VALUES ('959136569053151237', '107', 0, '2022-03-31 17:06:18', NULL, '2A1123I34', '959134190484324352', '107');
INSERT INTO `tb_room` VALUES ('959136569053151238', '108', 0, '2022-03-31 17:06:18', NULL, '2A1123I340', '959134190484324352', '108');
INSERT INTO `tb_room` VALUES ('959136569053151239', '109', 0, '2022-03-31 17:06:18', NULL, '2A1123I341', '959134190484324352', '109');
INSERT INTO `tb_room` VALUES ('959136569053151240', '110', 0, '2022-03-31 17:06:18', NULL, '2A1123I342', '959134190484324352', '110');
INSERT INTO `tb_room` VALUES ('959136569053151241', '201', 0, '2022-03-31 17:06:18', NULL, '2A1123I343', '959134190484324352', '201');
INSERT INTO `tb_room` VALUES ('959136569053151242', '202', 0, '2022-03-31 17:06:18', NULL, '2A1123I344', '959134190484324352', '202');
INSERT INTO `tb_room` VALUES ('959136569053151243', '203', 0, '2022-03-31 17:06:18', NULL, '2A1123I345', '959134190484324352', '203');
INSERT INTO `tb_room` VALUES ('959136569053151244', '204', 0, '2022-03-31 17:06:18', NULL, '2A1123I346', '959134190484324352', '204');
INSERT INTO `tb_room` VALUES ('959136569053151245', '205', 0, '2022-03-31 17:06:18', NULL, '2A1123I347', '959134190484324352', '205');
INSERT INTO `tb_room` VALUES ('959136569053151246', '206', 0, '2022-03-31 17:06:18', NULL, '2A1123I348', '959134190484324352', '206');
INSERT INTO `tb_room` VALUES ('959136569053151247', '207', 0, '2022-03-31 17:06:18', NULL, '2A1123I349', '959134190484324352', '207');
INSERT INTO `tb_room` VALUES ('959136569053151248', '208', 0, '2022-03-31 17:06:18', NULL, '2A1123I35', '959134190484324352', '208');
INSERT INTO `tb_room` VALUES ('959136569053151249', '209', 0, '2022-03-31 17:06:18', NULL, '2A1123I350', '959134190484324352', '209');
INSERT INTO `tb_room` VALUES ('959136569053151250', '210', 0, '2022-03-31 17:06:18', NULL, '2A1123I351', '959134190484324352', '210');
INSERT INTO `tb_room` VALUES ('959136569053151251', '301', 0, '2022-03-31 17:06:18', NULL, '2A1123I352', '959134190484324352', '301');
INSERT INTO `tb_room` VALUES ('959136569053151252', '302', 0, '2022-03-31 17:06:18', NULL, '2A1123I353', '959134190484324352', '302');
INSERT INTO `tb_room` VALUES ('959136569053151253', '303', 0, '2022-03-31 17:06:18', NULL, '2A1123I354', '959134190484324352', '303');
INSERT INTO `tb_room` VALUES ('959136569053151254', '304', 0, '2022-03-31 17:06:18', NULL, '2A1123I355', '959134190484324352', '304');
INSERT INTO `tb_room` VALUES ('959136569053151255', '305', 0, '2022-03-31 17:06:18', NULL, '2A1123I356', '959134190484324352', '305');
INSERT INTO `tb_room` VALUES ('959136569053151256', '306', 0, '2022-03-31 17:06:18', NULL, '2A1123I357', '959134190484324352', '306');
INSERT INTO `tb_room` VALUES ('959136569053151257', '307', 0, '2022-03-31 17:06:18', NULL, '2A1123I358', '959134190484324352', '307');
INSERT INTO `tb_room` VALUES ('959136569053151258', '308', 0, '2022-03-31 17:06:18', NULL, '2A1123I359', '959134190484324352', '308');
INSERT INTO `tb_room` VALUES ('959136569053151259', '309', 0, '2022-03-31 17:06:18', NULL, '2A1123I36', '959134190484324352', '309');
INSERT INTO `tb_room` VALUES ('959136569057345536', '310', 0, '2022-03-31 17:06:18', NULL, '2A1123I360', '959134190484324352', '310');
INSERT INTO `tb_room` VALUES ('959136645582422016', '101', 0, '2022-03-31 17:06:36', NULL, '2A1123I38', '959134190484324353', '101');
INSERT INTO `tb_room` VALUES ('959136645582422017', '102', 0, '2022-03-31 17:06:36', NULL, '2A1123I380', '959134190484324353', '102');
INSERT INTO `tb_room` VALUES ('959136645582422018', '103', 0, '2022-03-31 17:06:36', NULL, '2A1123I381', '959134190484324353', '103');
INSERT INTO `tb_room` VALUES ('959136645582422019', '104', 0, '2022-03-31 17:06:36', NULL, '2A1123I382', '959134190484324353', '104');
INSERT INTO `tb_room` VALUES ('959136645582422020', '105', 0, '2022-03-31 17:06:36', NULL, '2A1123I383', '959134190484324353', '105');
INSERT INTO `tb_room` VALUES ('959136645582422021', '106', 0, '2022-03-31 17:06:36', NULL, '2A1123I384', '959134190484324353', '106');
INSERT INTO `tb_room` VALUES ('959136645582422022', '107', 0, '2022-03-31 17:06:36', NULL, '2A1123I385', '959134190484324353', '107');
INSERT INTO `tb_room` VALUES ('959136645582422023', '108', 0, '2022-03-31 17:06:36', NULL, '2A1123I386', '959134190484324353', '108');
INSERT INTO `tb_room` VALUES ('959136645582422024', '109', 0, '2022-03-31 17:06:36', NULL, '2A1123I387', '959134190484324353', '109');
INSERT INTO `tb_room` VALUES ('959136645586616320', '110', 0, '2022-03-31 17:06:36', NULL, '2A1123I388', '959134190484324353', '110');
INSERT INTO `tb_room` VALUES ('959136645586616321', '201', 0, '2022-03-31 17:06:36', NULL, '2A1123I389', '959134190484324353', '201');
INSERT INTO `tb_room` VALUES ('959136645586616322', '202', 0, '2022-03-31 17:06:36', NULL, '2A1123I39', '959134190484324353', '202');
INSERT INTO `tb_room` VALUES ('959136645586616323', '203', 0, '2022-03-31 17:06:36', NULL, '2A1123I390', '959134190484324353', '203');
INSERT INTO `tb_room` VALUES ('959136645586616324', '204', 0, '2022-03-31 17:06:36', NULL, '2A1123I391', '959134190484324353', '204');
INSERT INTO `tb_room` VALUES ('959136645586616325', '205', 0, '2022-03-31 17:06:36', NULL, '2A1123I392', '959134190484324353', '205');
INSERT INTO `tb_room` VALUES ('959136645586616326', '206', 0, '2022-03-31 17:06:36', NULL, '2A1123I393', '959134190484324353', '206');
INSERT INTO `tb_room` VALUES ('959136645586616327', '207', 0, '2022-03-31 17:06:36', NULL, '2A1123I394', '959134190484324353', '207');
INSERT INTO `tb_room` VALUES ('959136645586616328', '208', 0, '2022-03-31 17:06:36', NULL, '2A1123I395', '959134190484324353', '208');
INSERT INTO `tb_room` VALUES ('959136645586616329', '209', 0, '2022-03-31 17:06:36', NULL, '2A1123I396', '959134190484324353', '209');
INSERT INTO `tb_room` VALUES ('959136645586616330', '210', 0, '2022-03-31 17:06:36', NULL, '2A1123I397', '959134190484324353', '210');
INSERT INTO `tb_room` VALUES ('959136645586616331', '301', 0, '2022-03-31 17:06:36', NULL, '2A1123I398', '959134190484324353', '301');
INSERT INTO `tb_room` VALUES ('959136645586616332', '302', 0, '2022-03-31 17:06:36', NULL, '2A1123I399', '959134190484324353', '302');
INSERT INTO `tb_room` VALUES ('959136645586616333', '303', 0, '2022-03-31 17:06:36', NULL, '2A1123I4', '959134190484324353', '303');
INSERT INTO `tb_room` VALUES ('959136645586616334', '304', 0, '2022-03-31 17:06:36', NULL, '2A1123I40', '959134190484324353', '304');
INSERT INTO `tb_room` VALUES ('959136645586616335', '305', 0, '2022-03-31 17:06:36', NULL, '2A1123I400', '959134190484324353', '305');
INSERT INTO `tb_room` VALUES ('959136645586616336', '306', 0, '2022-03-31 17:06:36', NULL, '2A1123I41', '959134190484324353', '306');
INSERT INTO `tb_room` VALUES ('959136645586616337', '307', 0, '2022-03-31 17:06:36', NULL, '2A1123I42', '959134190484324353', '307');
INSERT INTO `tb_room` VALUES ('959136645586616338', '308', 0, '2022-03-31 17:06:36', NULL, '2A1123I43', '959134190484324353', '308');
INSERT INTO `tb_room` VALUES ('959136645586616339', '309', 0, '2022-03-31 17:06:36', NULL, '2A1123I44', '959134190484324353', '309');
INSERT INTO `tb_room` VALUES ('959136645586616340', '310', 0, '2022-03-31 17:06:36', NULL, '2A1123I45', '959134190484324353', '310');
INSERT INTO `tb_room` VALUES ('959136676481859584', '101', 0, '2022-03-31 17:06:44', NULL, '2A1123I64', '959134190484324354', '101');
INSERT INTO `tb_room` VALUES ('959136676481859585', '102', 0, '2022-03-31 17:06:44', NULL, '2A1123I65', '959134190484324354', '102');
INSERT INTO `tb_room` VALUES ('959136676481859586', '103', 0, '2022-03-31 17:06:44', NULL, '2A1123I66', '959134190484324354', '103');
INSERT INTO `tb_room` VALUES ('959136676481859587', '104', 0, '2022-03-31 17:06:44', NULL, '2A1123I67', '959134190484324354', '104');
INSERT INTO `tb_room` VALUES ('959136676481859588', '105', 0, '2022-03-31 17:06:44', NULL, '2A1123I68', '959134190484324354', '105');
INSERT INTO `tb_room` VALUES ('959136676481859589', '106', 0, '2022-03-31 17:06:44', NULL, '2A1123I69', '959134190484324354', '106');
INSERT INTO `tb_room` VALUES ('959136676481859590', '107', 0, '2022-03-31 17:06:44', NULL, '2A1123I7', '959134190484324354', '107');
INSERT INTO `tb_room` VALUES ('959136676481859591', '108', 0, '2022-03-31 17:06:44', NULL, '2A1123I70', '959134190484324354', '108');
INSERT INTO `tb_room` VALUES ('959136676481859592', '109', 0, '2022-03-31 17:06:44', NULL, '2A1123I71', '959134190484324354', '109');
INSERT INTO `tb_room` VALUES ('959136676481859593', '110', 0, '2022-03-31 17:06:44', NULL, '2A1123I72', '959134190484324354', '110');
INSERT INTO `tb_room` VALUES ('959136676481859594', '201', 0, '2022-03-31 17:06:44', NULL, '2A1123I73', '959134190484324354', '201');
INSERT INTO `tb_room` VALUES ('959136676481859595', '202', 0, '2022-03-31 17:06:44', NULL, '2A1123I74', '959134190484324354', '202');
INSERT INTO `tb_room` VALUES ('959136676481859596', '203', 0, '2022-03-31 17:06:44', NULL, '2A1123I75', '959134190484324354', '203');
INSERT INTO `tb_room` VALUES ('959136676481859597', '204', 0, '2022-03-31 17:06:44', NULL, '2A1123I76', '959134190484324354', '204');
INSERT INTO `tb_room` VALUES ('959136676481859598', '205', 0, '2022-03-31 17:06:44', NULL, '2A1123I77', '959134190484324354', '205');
INSERT INTO `tb_room` VALUES ('959136676481859599', '206', 0, '2022-03-31 17:06:44', NULL, '2A1123I78', '959134190484324354', '206');
INSERT INTO `tb_room` VALUES ('959136676481859600', '207', 0, '2022-03-31 17:06:44', NULL, '2A1123I79', '959134190484324354', '207');
INSERT INTO `tb_room` VALUES ('959136676481859601', '208', 0, '2022-03-31 17:06:44', NULL, '2A1123I8', '959134190484324354', '208');
INSERT INTO `tb_room` VALUES ('959136676481859602', '209', 0, '2022-03-31 17:06:44', NULL, '2A1123I80', '959134190484324354', '209');
INSERT INTO `tb_room` VALUES ('959136676481859603', '210', 0, '2022-03-31 17:06:44', NULL, '2A1123I81', '959134190484324354', '210');
INSERT INTO `tb_room` VALUES ('959136676481859604', '301', 0, '2022-03-31 17:06:44', NULL, '2A1123I82', '959134190484324354', '301');
INSERT INTO `tb_room` VALUES ('959136676481859605', '302', 0, '2022-03-31 17:06:44', NULL, '2A1123I83', '959134190484324354', '302');
INSERT INTO `tb_room` VALUES ('959136676481859606', '303', 0, '2022-03-31 17:06:44', NULL, '2A1123I84', '959134190484324354', '303');
INSERT INTO `tb_room` VALUES ('959136676481859607', '304', 0, '2022-03-31 17:06:44', NULL, '2A1123I85', '959134190484324354', '304');
INSERT INTO `tb_room` VALUES ('959136676481859608', '305', 0, '2022-03-31 17:06:44', NULL, '2A1123I86', '959134190484324354', '305');
INSERT INTO `tb_room` VALUES ('959136676481859609', '306', 0, '2022-03-31 17:06:44', NULL, '2A1123I87', '959134190484324354', '306');
INSERT INTO `tb_room` VALUES ('959136676481859610', '307', 0, '2022-03-31 17:06:44', NULL, '2A1123I88', '959134190484324354', '307');
INSERT INTO `tb_room` VALUES ('959136676481859611', '308', 0, '2022-03-31 17:06:44', NULL, '2A1123I89', '959134190484324354', '308');
INSERT INTO `tb_room` VALUES ('959136676481859612', '309', 0, '2022-03-31 17:06:44', NULL, '2A1123I9', '959134190484324354', '309');
INSERT INTO `tb_room` VALUES ('959136676481859613', '310', 0, '2022-03-31 17:06:44', NULL, '2A1123I90', '959134190484324354', '310');
INSERT INTO `tb_room` VALUES ('959136699365982208', '101', 0, '2022-03-31 17:06:49', NULL, '2A1123J2', '959134190484324355', '101');
INSERT INTO `tb_room` VALUES ('959136699370176512', '102', 0, '2022-03-31 17:06:49', NULL, '2A1123J20', '959134190484324355', '102');
INSERT INTO `tb_room` VALUES ('959136699370176513', '103', 0, '2022-03-31 17:06:49', NULL, '2A1123J21', '959134190484324355', '103');
INSERT INTO `tb_room` VALUES ('959136699370176514', '104', 0, '2022-03-31 17:06:49', NULL, '2A1123J22', '959134190484324355', '104');
INSERT INTO `tb_room` VALUES ('959136699370176515', '105', 0, '2022-03-31 17:06:49', NULL, '2A1123J23', '959134190484324355', '105');
INSERT INTO `tb_room` VALUES ('959136699370176516', '106', 0, '2022-03-31 17:06:49', NULL, '2A1123J24', '959134190484324355', '106');
INSERT INTO `tb_room` VALUES ('959136699370176517', '107', 0, '2022-03-31 17:06:49', NULL, '2A1123J25', '959134190484324355', '107');
INSERT INTO `tb_room` VALUES ('959136699370176518', '108', 0, '2022-03-31 17:06:49', NULL, '2A1123J26', '959134190484324355', '108');
INSERT INTO `tb_room` VALUES ('959136699370176519', '109', 0, '2022-03-31 17:06:49', NULL, '2A1123J27', '959134190484324355', '109');
INSERT INTO `tb_room` VALUES ('959136699370176520', '110', 0, '2022-03-31 17:06:49', NULL, '2A1123J28', '959134190484324355', '110');
INSERT INTO `tb_room` VALUES ('959136699370176521', '201', 0, '2022-03-31 17:06:49', NULL, '2A1123J29', '959134190484324355', '201');
INSERT INTO `tb_room` VALUES ('959136699370176522', '202', 0, '2022-03-31 17:06:49', NULL, '2A1123J3', '959134190484324355', '202');
INSERT INTO `tb_room` VALUES ('959136699370176523', '203', 0, '2022-03-31 17:06:49', NULL, '2A1123J30', '959134190484324355', '203');
INSERT INTO `tb_room` VALUES ('959136699370176524', '204', 0, '2022-03-31 17:06:49', NULL, '2A1123J31', '959134190484324355', '204');
INSERT INTO `tb_room` VALUES ('959136699370176525', '205', 0, '2022-03-31 17:06:49', NULL, '2A1123J32', '959134190484324355', '205');
INSERT INTO `tb_room` VALUES ('959136699370176526', '206', 0, '2022-03-31 17:06:49', NULL, '2A1123J33', '959134190484324355', '206');
INSERT INTO `tb_room` VALUES ('959136699370176527', '207', 0, '2022-03-31 17:06:49', NULL, '2A1123J34', '959134190484324355', '207');
INSERT INTO `tb_room` VALUES ('959136699370176528', '208', 0, '2022-03-31 17:06:49', NULL, '2A1123J35', '959134190484324355', '208');
INSERT INTO `tb_room` VALUES ('959136699370176529', '209', 0, '2022-03-31 17:06:49', NULL, '2A1123J36', '959134190484324355', '209');
INSERT INTO `tb_room` VALUES ('959136699370176530', '210', 0, '2022-03-31 17:06:49', NULL, '2A1123J37', '959134190484324355', '210');
INSERT INTO `tb_room` VALUES ('959136699370176531', '301', 0, '2022-03-31 17:06:49', NULL, '2A1123J38', '959134190484324355', '301');
INSERT INTO `tb_room` VALUES ('959136699370176532', '302', 0, '2022-03-31 17:06:49', NULL, '2A1123J39', '959134190484324355', '302');
INSERT INTO `tb_room` VALUES ('959136699370176533', '303', 0, '2022-03-31 17:06:49', NULL, '2A1123J4', '959134190484324355', '303');
INSERT INTO `tb_room` VALUES ('959136699370176534', '304', 0, '2022-03-31 17:06:49', NULL, '2A1123J40', '959134190484324355', '304');
INSERT INTO `tb_room` VALUES ('959136699370176535', '305', 0, '2022-03-31 17:06:49', NULL, '2A1123J41', '959134190484324355', '305');
INSERT INTO `tb_room` VALUES ('959136699370176536', '306', 0, '2022-03-31 17:06:49', NULL, '2A1123J42', '959134190484324355', '306');
INSERT INTO `tb_room` VALUES ('959136699370176537', '307', 0, '2022-03-31 17:06:49', NULL, '2A1123J43', '959134190484324355', '307');
INSERT INTO `tb_room` VALUES ('959136699370176538', '308', 0, '2022-03-31 17:06:49', NULL, '2A1123J44', '959134190484324355', '308');
INSERT INTO `tb_room` VALUES ('959136699370176539', '309', 0, '2022-03-31 17:06:49', NULL, '2A1123J45', '959134190484324355', '309');
INSERT INTO `tb_room` VALUES ('959136699370176540', '310', 0, '2022-03-31 17:06:49', NULL, '2A1123J46', '959134190484324355', '310');
INSERT INTO `tb_room` VALUES ('959136747659198464', '101', 0, '2022-03-31 17:07:01', NULL, '2A1123I118', '959133970614714368', '101');
INSERT INTO `tb_room` VALUES ('959136747659198465', '102', 0, '2022-03-31 17:07:01', NULL, '2A1123I119', '959133970614714368', '102');
INSERT INTO `tb_room` VALUES ('959136747659198466', '103', 0, '2022-03-31 17:07:01', NULL, '2A1123I12', '959133970614714368', '103');
INSERT INTO `tb_room` VALUES ('959136747659198467', '104', 0, '2022-03-31 17:07:01', NULL, '2A1123I120', '959133970614714368', '104');
INSERT INTO `tb_room` VALUES ('959136747659198468', '105', 0, '2022-03-31 17:07:01', NULL, '2A1123I121', '959133970614714368', '105');
INSERT INTO `tb_room` VALUES ('959136747659198469', '106', 0, '2022-03-31 17:07:01', NULL, '2A1123I122', '959133970614714368', '106');
INSERT INTO `tb_room` VALUES ('959136747659198470', '107', 0, '2022-03-31 17:07:01', NULL, '2A1123I123', '959133970614714368', '107');
INSERT INTO `tb_room` VALUES ('959136747659198471', '108', 0, '2022-03-31 17:07:01', NULL, '2A1123I124', '959133970614714368', '108');
INSERT INTO `tb_room` VALUES ('959136747659198472', '109', 0, '2022-03-31 17:07:01', NULL, '2A1123I125', '959133970614714368', '109');
INSERT INTO `tb_room` VALUES ('959136747659198473', '110', 0, '2022-03-31 17:07:01', NULL, '2A1123I126', '959133970614714368', '110');
INSERT INTO `tb_room` VALUES ('959136747659198474', '201', 0, '2022-03-31 17:07:01', NULL, '2A1123I127', '959133970614714368', '201');
INSERT INTO `tb_room` VALUES ('959136747659198475', '202', 0, '2022-03-31 17:07:01', NULL, '2A1123I128', '959133970614714368', '202');
INSERT INTO `tb_room` VALUES ('959136747659198476', '203', 0, '2022-03-31 17:07:01', NULL, '2A1123I129', '959133970614714368', '203');
INSERT INTO `tb_room` VALUES ('959136747659198477', '204', 0, '2022-03-31 17:07:01', NULL, '2A1123I13', '959133970614714368', '204');
INSERT INTO `tb_room` VALUES ('959136747659198478', '205', 0, '2022-03-31 17:07:01', NULL, '2A1123I130', '959133970614714368', '205');
INSERT INTO `tb_room` VALUES ('959136747659198479', '206', 0, '2022-03-31 17:07:01', NULL, '2A1123I131', '959133970614714368', '206');
INSERT INTO `tb_room` VALUES ('959136747659198480', '207', 0, '2022-03-31 17:07:01', NULL, '2A1123I132', '959133970614714368', '207');
INSERT INTO `tb_room` VALUES ('959136747659198481', '208', 0, '2022-03-31 17:07:01', NULL, '2A1123I133', '959133970614714368', '208');
INSERT INTO `tb_room` VALUES ('959136747659198482', '209', 0, '2022-03-31 17:07:01', NULL, '2A1123I134', '959133970614714368', '209');
INSERT INTO `tb_room` VALUES ('959136747659198483', '210', 0, '2022-03-31 17:07:01', NULL, '2A1123I135', '959133970614714368', '210');
INSERT INTO `tb_room` VALUES ('959136747659198484', '301', 0, '2022-03-31 17:07:01', NULL, '2A1123I136', '959133970614714368', '301');
INSERT INTO `tb_room` VALUES ('959136747659198485', '302', 0, '2022-03-31 17:07:01', NULL, '2A1123I137', '959133970614714368', '302');
INSERT INTO `tb_room` VALUES ('959136747659198486', '303', 0, '2022-03-31 17:07:01', NULL, '2A1123I138', '959133970614714368', '303');
INSERT INTO `tb_room` VALUES ('959136747659198487', '304', 0, '2022-03-31 17:07:01', NULL, '2A1123I139', '959133970614714368', '304');
INSERT INTO `tb_room` VALUES ('959136747659198488', '305', 0, '2022-03-31 17:07:01', NULL, '2A1123I14', '959133970614714368', '305');
INSERT INTO `tb_room` VALUES ('959136747659198489', '306', 0, '2022-03-31 17:07:01', NULL, '2A1123I140', '959133970614714368', '306');
INSERT INTO `tb_room` VALUES ('959136747659198490', '307', 0, '2022-03-31 17:07:01', NULL, '2A1123I141', '959133970614714368', '307');
INSERT INTO `tb_room` VALUES ('959136747659198491', '308', 0, '2022-03-31 17:07:01', NULL, '2A1123I142', '959133970614714368', '308');
INSERT INTO `tb_room` VALUES ('959136747659198492', '309', 0, '2022-03-31 17:07:01', NULL, '2A1123I143', '959133970614714368', '309');
INSERT INTO `tb_room` VALUES ('959136747659198493', '310', 0, '2022-03-31 17:07:01', NULL, '2A1123I144', '959133970614714368', '310');
INSERT INTO `tb_room` VALUES ('959136769054343168', '101', 0, '2022-03-31 17:07:06', NULL, '2A1123I145', '959133970614714369', '101');
INSERT INTO `tb_room` VALUES ('959136769054343169', '102', 0, '2022-03-31 17:07:06', NULL, '2A1123I146', '959133970614714369', '102');
INSERT INTO `tb_room` VALUES ('959136769054343170', '103', 0, '2022-03-31 17:07:06', NULL, '2A1123I147', '959133970614714369', '103');
INSERT INTO `tb_room` VALUES ('959136769054343171', '104', 0, '2022-03-31 17:07:06', NULL, '2A1123I148', '959133970614714369', '104');
INSERT INTO `tb_room` VALUES ('959136769054343172', '105', 0, '2022-03-31 17:07:06', NULL, '2A1123I149', '959133970614714369', '105');
INSERT INTO `tb_room` VALUES ('959136769054343173', '106', 0, '2022-03-31 17:07:06', NULL, '2A1123I15', '959133970614714369', '106');
INSERT INTO `tb_room` VALUES ('959136769054343174', '107', 0, '2022-03-31 17:07:06', NULL, '2A1123I150', '959133970614714369', '107');
INSERT INTO `tb_room` VALUES ('959136769054343175', '108', 0, '2022-03-31 17:07:06', NULL, '2A1123I151', '959133970614714369', '108');
INSERT INTO `tb_room` VALUES ('959136769054343176', '109', 0, '2022-03-31 17:07:06', NULL, '2A1123I152', '959133970614714369', '109');
INSERT INTO `tb_room` VALUES ('959136769054343177', '110', 0, '2022-03-31 17:07:06', NULL, '2A1123I153', '959133970614714369', '110');
INSERT INTO `tb_room` VALUES ('959136769054343178', '201', 0, '2022-03-31 17:07:06', NULL, '2A1123I154', '959133970614714369', '201');
INSERT INTO `tb_room` VALUES ('959136769054343179', '202', 0, '2022-03-31 17:07:06', NULL, '2A1123I155', '959133970614714369', '202');
INSERT INTO `tb_room` VALUES ('959136769054343180', '203', 0, '2022-03-31 17:07:06', NULL, '2A1123I156', '959133970614714369', '203');
INSERT INTO `tb_room` VALUES ('959136769054343181', '204', 0, '2022-03-31 17:07:06', NULL, '2A1123I157', '959133970614714369', '204');
INSERT INTO `tb_room` VALUES ('959136769054343182', '205', 0, '2022-03-31 17:07:06', NULL, '2A1123I158', '959133970614714369', '205');
INSERT INTO `tb_room` VALUES ('959136769054343183', '206', 0, '2022-03-31 17:07:06', NULL, '2A1123I159', '959133970614714369', '206');
INSERT INTO `tb_room` VALUES ('959136769054343184', '207', 0, '2022-03-31 17:07:06', NULL, '2A1123I16', '959133970614714369', '207');
INSERT INTO `tb_room` VALUES ('959136769054343185', '208', 0, '2022-03-31 17:07:06', NULL, '2A1123I160', '959133970614714369', '208');
INSERT INTO `tb_room` VALUES ('959136769054343186', '209', 0, '2022-03-31 17:07:06', NULL, '2A1123I161', '959133970614714369', '209');
INSERT INTO `tb_room` VALUES ('959136769054343187', '210', 0, '2022-03-31 17:07:06', NULL, '2A1123I162', '959133970614714369', '210');
INSERT INTO `tb_room` VALUES ('959136769054343188', '301', 0, '2022-03-31 17:07:06', NULL, '2A1123I163', '959133970614714369', '301');
INSERT INTO `tb_room` VALUES ('959136769054343189', '302', 0, '2022-03-31 17:07:06', NULL, '2A1123I164', '959133970614714369', '302');
INSERT INTO `tb_room` VALUES ('959136769054343190', '303', 0, '2022-03-31 17:07:06', NULL, '2A1123I165', '959133970614714369', '303');
INSERT INTO `tb_room` VALUES ('959136769054343191', '304', 0, '2022-03-31 17:07:06', NULL, '2A1123I166', '959133970614714369', '304');
INSERT INTO `tb_room` VALUES ('959136769054343192', '305', 0, '2022-03-31 17:07:06', NULL, '2A1123I167', '959133970614714369', '305');
INSERT INTO `tb_room` VALUES ('959136769054343193', '306', 0, '2022-03-31 17:07:06', NULL, '2A1123I168', '959133970614714369', '306');
INSERT INTO `tb_room` VALUES ('959136769054343194', '307', 0, '2022-03-31 17:07:06', NULL, '2A1123I169', '959133970614714369', '307');
INSERT INTO `tb_room` VALUES ('959136769054343195', '308', 0, '2022-03-31 17:07:06', NULL, '2A1123I17', '959133970614714369', '308');
INSERT INTO `tb_room` VALUES ('959136769054343196', '309', 0, '2022-03-31 17:07:06', NULL, '2A1123I170', '959133970614714369', '309');
INSERT INTO `tb_room` VALUES ('959136769054343197', '310', 0, '2022-03-31 17:07:06', NULL, '2A1123I171', '959133970614714369', '310');
INSERT INTO `tb_room` VALUES ('959136788566245376', '101', 0, '2022-03-31 17:07:10', NULL, '2A1123I172', '959133970614714370', '101');
INSERT INTO `tb_room` VALUES ('959136788566245377', '102', 0, '2022-03-31 17:07:10', NULL, '2A1123I173', '959133970614714370', '102');
INSERT INTO `tb_room` VALUES ('959136788566245378', '103', 0, '2022-03-31 17:07:10', NULL, '2A1123I174', '959133970614714370', '103');
INSERT INTO `tb_room` VALUES ('959136788566245379', '104', 0, '2022-03-31 17:07:10', NULL, '2A1123I175', '959133970614714370', '104');
INSERT INTO `tb_room` VALUES ('959136788566245380', '105', 0, '2022-03-31 17:07:10', NULL, '2A1123I176', '959133970614714370', '105');
INSERT INTO `tb_room` VALUES ('959136788566245381', '106', 0, '2022-03-31 17:07:10', NULL, '2A1123I177', '959133970614714370', '106');
INSERT INTO `tb_room` VALUES ('959136788566245382', '107', 0, '2022-03-31 17:07:10', NULL, '2A1123I178', '959133970614714370', '107');
INSERT INTO `tb_room` VALUES ('959136788566245383', '108', 0, '2022-03-31 17:07:10', NULL, '2A1123I179', '959133970614714370', '108');
INSERT INTO `tb_room` VALUES ('959136788566245384', '109', 0, '2022-03-31 17:07:10', NULL, '2A1123I18', '959133970614714370', '109');
INSERT INTO `tb_room` VALUES ('959136788566245385', '110', 0, '2022-03-31 17:07:10', NULL, '2A1123I180', '959133970614714370', '110');
INSERT INTO `tb_room` VALUES ('959136788566245386', '201', 0, '2022-03-31 17:07:10', NULL, '2A1123I181', '959133970614714370', '201');
INSERT INTO `tb_room` VALUES ('959136788566245387', '202', 0, '2022-03-31 17:07:10', NULL, '2A1123I182', '959133970614714370', '202');
INSERT INTO `tb_room` VALUES ('959136788570439680', '203', 0, '2022-03-31 17:07:10', NULL, '2A1123I183', '959133970614714370', '203');
INSERT INTO `tb_room` VALUES ('959136788570439681', '204', 0, '2022-03-31 17:07:10', NULL, '2A1123I184', '959133970614714370', '204');
INSERT INTO `tb_room` VALUES ('959136788570439682', '205', 0, '2022-03-31 17:07:10', NULL, '2A1123I185', '959133970614714370', '205');
INSERT INTO `tb_room` VALUES ('959136788570439683', '206', 0, '2022-03-31 17:07:10', NULL, '2A1123I186', '959133970614714370', '206');
INSERT INTO `tb_room` VALUES ('959136788570439684', '207', 0, '2022-03-31 17:07:10', NULL, '2A1123I187', '959133970614714370', '207');
INSERT INTO `tb_room` VALUES ('959136788570439685', '208', 0, '2022-03-31 17:07:10', NULL, '2A1123I188', '959133970614714370', '208');
INSERT INTO `tb_room` VALUES ('959136788570439686', '209', 0, '2022-03-31 17:07:10', NULL, '2A1123I189', '959133970614714370', '209');
INSERT INTO `tb_room` VALUES ('959136788570439687', '210', 0, '2022-03-31 17:07:10', NULL, '2A1123I19', '959133970614714370', '210');
INSERT INTO `tb_room` VALUES ('959136788570439688', '301', 0, '2022-03-31 17:07:10', NULL, '2A1123I190', '959133970614714370', '301');
INSERT INTO `tb_room` VALUES ('959136788570439689', '302', 0, '2022-03-31 17:07:10', NULL, '2A1123I191', '959133970614714370', '302');
INSERT INTO `tb_room` VALUES ('959136788570439690', '303', 0, '2022-03-31 17:07:10', NULL, '2A1123I192', '959133970614714370', '303');
INSERT INTO `tb_room` VALUES ('959136788570439691', '304', 0, '2022-03-31 17:07:10', NULL, '2A1123I193', '959133970614714370', '304');
INSERT INTO `tb_room` VALUES ('959136788570439692', '305', 0, '2022-03-31 17:07:10', NULL, '2A1123I194', '959133970614714370', '305');
INSERT INTO `tb_room` VALUES ('959136788570439693', '306', 0, '2022-03-31 17:07:10', NULL, '2A1123I195', '959133970614714370', '306');
INSERT INTO `tb_room` VALUES ('959136788570439694', '307', 0, '2022-03-31 17:07:10', NULL, '2A1123I196', '959133970614714370', '307');
INSERT INTO `tb_room` VALUES ('959136788570439695', '308', 0, '2022-03-31 17:07:10', NULL, '2A1123I197', '959133970614714370', '308');
INSERT INTO `tb_room` VALUES ('959136788570439696', '309', 0, '2022-03-31 17:07:10', NULL, '2A1123I198', '959133970614714370', '309');
INSERT INTO `tb_room` VALUES ('959136788570439697', '310', 0, '2022-03-31 17:07:10', NULL, '2A1123I199', '959133970614714370', '310');
INSERT INTO `tb_room` VALUES ('959136809265135616', '101', 0, '2022-03-31 17:07:15', NULL, '2A1123I2', '959133970614714371', '101');
INSERT INTO `tb_room` VALUES ('959136809265135617', '102', 0, '2022-03-31 17:07:15', NULL, '2A1123I20', '959133970614714371', '102');
INSERT INTO `tb_room` VALUES ('959136809265135618', '103', 0, '2022-03-31 17:07:15', NULL, '2A1123I200', '959133970614714371', '103');
INSERT INTO `tb_room` VALUES ('959136809265135619', '104', 0, '2022-03-31 17:07:15', NULL, '2A1123I201', '959133970614714371', '104');
INSERT INTO `tb_room` VALUES ('959136809265135620', '105', 0, '2022-03-31 17:07:15', NULL, '2A1123I202', '959133970614714371', '105');
INSERT INTO `tb_room` VALUES ('959136809265135621', '106', 0, '2022-03-31 17:07:15', NULL, '2A1123I203', '959133970614714371', '106');
INSERT INTO `tb_room` VALUES ('959136809265135622', '107', 0, '2022-03-31 17:07:15', NULL, '2A1123I204', '959133970614714371', '107');
INSERT INTO `tb_room` VALUES ('959136809265135623', '108', 0, '2022-03-31 17:07:15', NULL, '2A1123I205', '959133970614714371', '108');
INSERT INTO `tb_room` VALUES ('959136809265135624', '109', 0, '2022-03-31 17:07:15', NULL, '2A1123I206', '959133970614714371', '109');
INSERT INTO `tb_room` VALUES ('959136809265135625', '110', 0, '2022-03-31 17:07:15', NULL, '2A1123I207', '959133970614714371', '110');
INSERT INTO `tb_room` VALUES ('959136809265135626', '201', 0, '2022-03-31 17:07:15', NULL, '2A1123I208', '959133970614714371', '201');
INSERT INTO `tb_room` VALUES ('959136809265135627', '202', 0, '2022-03-31 17:07:15', NULL, '2A1123I209', '959133970614714371', '202');
INSERT INTO `tb_room` VALUES ('959136809265135628', '203', 0, '2022-03-31 17:07:15', NULL, '2A1123I21', '959133970614714371', '203');
INSERT INTO `tb_room` VALUES ('959136809265135629', '204', 0, '2022-03-31 17:07:15', NULL, '2A1123I210', '959133970614714371', '204');
INSERT INTO `tb_room` VALUES ('959136809265135630', '205', 0, '2022-03-31 17:07:15', NULL, '2A1123I211', '959133970614714371', '205');
INSERT INTO `tb_room` VALUES ('959136809265135631', '206', 0, '2022-03-31 17:07:15', NULL, '2A1123I212', '959133970614714371', '206');
INSERT INTO `tb_room` VALUES ('959136809269329920', '207', 0, '2022-03-31 17:07:15', NULL, '2A1123I213', '959133970614714371', '207');
INSERT INTO `tb_room` VALUES ('959136809269329921', '208', 0, '2022-03-31 17:07:15', NULL, '2A1123I214', '959133970614714371', '208');
INSERT INTO `tb_room` VALUES ('959136809269329922', '209', 0, '2022-03-31 17:07:15', NULL, '2A1123I215', '959133970614714371', '209');
INSERT INTO `tb_room` VALUES ('959136809269329923', '210', 0, '2022-03-31 17:07:15', NULL, '2A1123I216', '959133970614714371', '210');
INSERT INTO `tb_room` VALUES ('959136809269329924', '301', 0, '2022-03-31 17:07:15', NULL, '2A1123I217', '959133970614714371', '301');
INSERT INTO `tb_room` VALUES ('959136809269329925', '302', 0, '2022-03-31 17:07:15', NULL, '2A1123I218', '959133970614714371', '302');
INSERT INTO `tb_room` VALUES ('959136809269329926', '303', 0, '2022-03-31 17:07:15', NULL, '2A1123I219', '959133970614714371', '303');
INSERT INTO `tb_room` VALUES ('959136809269329927', '304', 0, '2022-03-31 17:07:15', NULL, '2A1123I22', '959133970614714371', '304');
INSERT INTO `tb_room` VALUES ('959136809269329928', '305', 0, '2022-03-31 17:07:15', NULL, '2A1123I220', '959133970614714371', '305');
INSERT INTO `tb_room` VALUES ('959136809269329929', '306', 0, '2022-03-31 17:07:15', NULL, '2A1123I221', '959133970614714371', '306');
INSERT INTO `tb_room` VALUES ('959136809269329930', '307', 0, '2022-03-31 17:07:15', NULL, '2A1123I222', '959133970614714371', '307');
INSERT INTO `tb_room` VALUES ('959136809269329931', '308', 0, '2022-03-31 17:07:15', NULL, '2A1123I223', '959133970614714371', '308');
INSERT INTO `tb_room` VALUES ('959136809269329932', '309', 0, '2022-03-31 17:07:15', NULL, '2A1123I224', '959133970614714371', '309');
INSERT INTO `tb_room` VALUES ('959136809269329933', '310', 0, '2022-03-31 17:07:15', NULL, '2A1123I225', '959133970614714371', '310');
INSERT INTO `tb_room` VALUES ('959136830836441088', '101', 0, '2022-03-31 17:07:20', NULL, '2A1123I226', '959133970614714372', '101');
INSERT INTO `tb_room` VALUES ('959136830836441089', '102', 0, '2022-03-31 17:07:20', NULL, '2A1123I227', '959133970614714372', '102');
INSERT INTO `tb_room` VALUES ('959136830836441090', '103', 0, '2022-03-31 17:07:20', NULL, '2A1123I228', '959133970614714372', '103');
INSERT INTO `tb_room` VALUES ('959136830836441091', '104', 0, '2022-03-31 17:07:20', NULL, '2A1123I229', '959133970614714372', '104');
INSERT INTO `tb_room` VALUES ('959136830836441092', '105', 0, '2022-03-31 17:07:20', NULL, '2A1123I23', '959133970614714372', '105');
INSERT INTO `tb_room` VALUES ('959136830836441093', '106', 0, '2022-03-31 17:07:20', NULL, '2A1123I230', '959133970614714372', '106');
INSERT INTO `tb_room` VALUES ('959136830836441094', '107', 0, '2022-03-31 17:07:20', NULL, '2A1123I231', '959133970614714372', '107');
INSERT INTO `tb_room` VALUES ('959136830836441095', '108', 0, '2022-03-31 17:07:20', NULL, '2A1123I232', '959133970614714372', '108');
INSERT INTO `tb_room` VALUES ('959136830836441096', '109', 0, '2022-03-31 17:07:20', NULL, '2A1123I233', '959133970614714372', '109');
INSERT INTO `tb_room` VALUES ('959136830836441097', '110', 0, '2022-03-31 17:07:20', NULL, '2A1123I234', '959133970614714372', '110');
INSERT INTO `tb_room` VALUES ('959136830836441098', '201', 0, '2022-03-31 17:07:20', NULL, '2A1123I235', '959133970614714372', '201');
INSERT INTO `tb_room` VALUES ('959136830836441099', '202', 0, '2022-03-31 17:07:20', NULL, '2A1123I236', '959133970614714372', '202');
INSERT INTO `tb_room` VALUES ('959136830836441100', '203', 0, '2022-03-31 17:07:20', NULL, '2A1123I237', '959133970614714372', '203');
INSERT INTO `tb_room` VALUES ('959136830836441101', '204', 0, '2022-03-31 17:07:20', NULL, '2A1123I238', '959133970614714372', '204');
INSERT INTO `tb_room` VALUES ('959136830836441102', '205', 0, '2022-03-31 17:07:20', NULL, '2A1123I239', '959133970614714372', '205');
INSERT INTO `tb_room` VALUES ('959136830836441103', '206', 0, '2022-03-31 17:07:20', NULL, '2A1123I24', '959133970614714372', '206');
INSERT INTO `tb_room` VALUES ('959136830836441104', '207', 0, '2022-03-31 17:07:20', NULL, '2A1123I240', '959133970614714372', '207');
INSERT INTO `tb_room` VALUES ('959136830836441105', '208', 0, '2022-03-31 17:07:20', NULL, '2A1123I241', '959133970614714372', '208');
INSERT INTO `tb_room` VALUES ('959136830836441106', '209', 0, '2022-03-31 17:07:20', NULL, '2A1123I242', '959133970614714372', '209');
INSERT INTO `tb_room` VALUES ('959136830836441107', '210', 0, '2022-03-31 17:07:20', NULL, '2A1123I243', '959133970614714372', '210');
INSERT INTO `tb_room` VALUES ('959136830836441108', '301', 0, '2022-03-31 17:07:20', NULL, '2A1123I244', '959133970614714372', '301');
INSERT INTO `tb_room` VALUES ('959136830836441109', '302', 0, '2022-03-31 17:07:20', NULL, '2A1123I245', '959133970614714372', '302');
INSERT INTO `tb_room` VALUES ('959136830836441110', '303', 0, '2022-03-31 17:07:20', NULL, '2A1123I246', '959133970614714372', '303');
INSERT INTO `tb_room` VALUES ('959136830836441111', '304', 0, '2022-03-31 17:07:20', NULL, '2A1123I247', '959133970614714372', '304');
INSERT INTO `tb_room` VALUES ('959136830836441112', '305', 0, '2022-03-31 17:07:20', NULL, '2A1123I248', '959133970614714372', '305');
INSERT INTO `tb_room` VALUES ('959136830836441113', '306', 0, '2022-03-31 17:07:20', NULL, '2A1123I249', '959133970614714372', '306');
INSERT INTO `tb_room` VALUES ('959136830836441114', '307', 0, '2022-03-31 17:07:20', NULL, '2A1123I25', '959133970614714372', '307');
INSERT INTO `tb_room` VALUES ('959136830836441115', '308', 0, '2022-03-31 17:07:20', NULL, '2A1123I250', '959133970614714372', '308');
INSERT INTO `tb_room` VALUES ('959136830836441116', '309', 0, '2022-03-31 17:07:20', NULL, '2A1123I251', '959133970614714372', '309');
INSERT INTO `tb_room` VALUES ('959136830836441117', '310', 0, '2022-03-31 17:07:20', NULL, '2A1123I252', '959133970614714372', '310');
INSERT INTO `tb_room` VALUES ('959136849907941376', '101', 0, '2022-03-31 17:07:25', NULL, '2A1123I253', '959133970614714373', '101');
INSERT INTO `tb_room` VALUES ('959136849907941377', '102', 0, '2022-03-31 17:07:25', NULL, '2A1123I254', '959133970614714373', '102');
INSERT INTO `tb_room` VALUES ('959136849907941378', '103', 0, '2022-03-31 17:07:25', NULL, '2A1123I255', '959133970614714373', '103');
INSERT INTO `tb_room` VALUES ('959136849907941379', '104', 0, '2022-03-31 17:07:25', NULL, '2A1123I256', '959133970614714373', '104');
INSERT INTO `tb_room` VALUES ('959136849907941380', '105', 0, '2022-03-31 17:07:25', NULL, '2A1123I257', '959133970614714373', '105');
INSERT INTO `tb_room` VALUES ('959136849907941381', '106', 0, '2022-03-31 17:07:25', NULL, '2A1123I258', '959133970614714373', '106');
INSERT INTO `tb_room` VALUES ('959136849907941382', '107', 0, '2022-03-31 17:07:25', NULL, '2A1123I259', '959133970614714373', '107');
INSERT INTO `tb_room` VALUES ('959136849907941383', '108', 0, '2022-03-31 17:07:25', NULL, '2A1123I26', '959133970614714373', '108');
INSERT INTO `tb_room` VALUES ('959136849907941384', '109', 0, '2022-03-31 17:07:25', NULL, '2A1123I260', '959133970614714373', '109');
INSERT INTO `tb_room` VALUES ('959136849907941385', '110', 0, '2022-03-31 17:07:25', NULL, '2A1123I261', '959133970614714373', '110');
INSERT INTO `tb_room` VALUES ('959136849907941386', '201', 0, '2022-03-31 17:07:25', NULL, '2A1123I262', '959133970614714373', '201');
INSERT INTO `tb_room` VALUES ('959136849907941387', '202', 0, '2022-03-31 17:07:25', NULL, '2A1123I263', '959133970614714373', '202');
INSERT INTO `tb_room` VALUES ('959136849907941388', '203', 0, '2022-03-31 17:07:25', NULL, '2A1123I264', '959133970614714373', '203');
INSERT INTO `tb_room` VALUES ('959136849907941389', '204', 0, '2022-03-31 17:07:25', NULL, '2A1123I265', '959133970614714373', '204');
INSERT INTO `tb_room` VALUES ('959136849907941390', '205', 0, '2022-03-31 17:07:25', NULL, '2A1123I266', '959133970614714373', '205');
INSERT INTO `tb_room` VALUES ('959136849912135680', '206', 0, '2022-03-31 17:07:25', NULL, '2A1123I267', '959133970614714373', '206');
INSERT INTO `tb_room` VALUES ('959136849912135681', '207', 0, '2022-03-31 17:07:25', NULL, '2A1123I268', '959133970614714373', '207');
INSERT INTO `tb_room` VALUES ('959136849912135682', '208', 0, '2022-03-31 17:07:25', NULL, '2A1123I269', '959133970614714373', '208');
INSERT INTO `tb_room` VALUES ('959136849912135683', '209', 0, '2022-03-31 17:07:25', NULL, '2A1123I27', '959133970614714373', '209');
INSERT INTO `tb_room` VALUES ('959136849912135684', '210', 0, '2022-03-31 17:07:25', NULL, '2A1123I270', '959133970614714373', '210');
INSERT INTO `tb_room` VALUES ('959136849912135685', '301', 0, '2022-03-31 17:07:25', NULL, '2A1123I271', '959133970614714373', '301');
INSERT INTO `tb_room` VALUES ('959136849912135686', '302', 0, '2022-03-31 17:07:25', NULL, '2A1123I272', '959133970614714373', '302');
INSERT INTO `tb_room` VALUES ('959136849912135687', '303', 0, '2022-03-31 17:07:25', NULL, '2A1123I273', '959133970614714373', '303');
INSERT INTO `tb_room` VALUES ('959136849912135688', '304', 0, '2022-03-31 17:07:25', NULL, '2A1123I274', '959133970614714373', '304');
INSERT INTO `tb_room` VALUES ('959136849912135689', '305', 0, '2022-03-31 17:07:25', NULL, '2A1123I275', '959133970614714373', '305');
INSERT INTO `tb_room` VALUES ('959136849912135690', '306', 0, '2022-03-31 17:07:25', NULL, '2A1123I276', '959133970614714373', '306');
INSERT INTO `tb_room` VALUES ('959136849912135691', '307', 0, '2022-03-31 17:07:25', NULL, '2A1123I277', '959133970614714373', '307');
INSERT INTO `tb_room` VALUES ('959136849912135692', '308', 0, '2022-03-31 17:07:25', NULL, '2A1123I278', '959133970614714373', '308');
INSERT INTO `tb_room` VALUES ('959136849912135693', '309', 0, '2022-03-31 17:07:25', NULL, '2A1123I279', '959133970614714373', '309');
INSERT INTO `tb_room` VALUES ('959136849912135694', '310', 0, '2022-03-31 17:07:25', NULL, '2A1123I28', '959133970614714373', '310');
INSERT INTO `tb_room` VALUES ('959136872259387392', '101', 0, '2022-03-31 17:07:30', NULL, '2A1123I280', '959133970614714374', '101');
INSERT INTO `tb_room` VALUES ('959136872259387393', '102', 0, '2022-03-31 17:07:30', NULL, '2A1123I281', '959133970614714374', '102');
INSERT INTO `tb_room` VALUES ('959136872259387394', '103', 0, '2022-03-31 17:07:30', NULL, '2A1123I282', '959133970614714374', '103');
INSERT INTO `tb_room` VALUES ('959136872259387395', '104', 0, '2022-03-31 17:07:30', NULL, '2A1123I283', '959133970614714374', '104');
INSERT INTO `tb_room` VALUES ('959136872259387396', '105', 0, '2022-03-31 17:07:30', NULL, '2A1123I284', '959133970614714374', '105');
INSERT INTO `tb_room` VALUES ('959136872259387397', '106', 0, '2022-03-31 17:07:30', NULL, '2A1123I285', '959133970614714374', '106');
INSERT INTO `tb_room` VALUES ('959136872259387398', '107', 0, '2022-03-31 17:07:30', NULL, '2A1123I286', '959133970614714374', '107');
INSERT INTO `tb_room` VALUES ('959136872259387399', '108', 0, '2022-03-31 17:07:30', NULL, '2A1123I287', '959133970614714374', '108');
INSERT INTO `tb_room` VALUES ('959136872259387400', '109', 0, '2022-03-31 17:07:30', NULL, '2A1123I288', '959133970614714374', '109');
INSERT INTO `tb_room` VALUES ('959136872259387401', '110', 0, '2022-03-31 17:07:30', NULL, '2A1123I289', '959133970614714374', '110');
INSERT INTO `tb_room` VALUES ('959136872259387402', '201', 0, '2022-03-31 17:07:30', NULL, '2A1123I29', '959133970614714374', '201');
INSERT INTO `tb_room` VALUES ('959136872259387403', '202', 0, '2022-03-31 17:07:30', NULL, '2A1123I290', '959133970614714374', '202');
INSERT INTO `tb_room` VALUES ('959136872259387404', '203', 0, '2022-03-31 17:07:30', NULL, '2A1123I291', '959133970614714374', '203');
INSERT INTO `tb_room` VALUES ('959136872259387405', '204', 0, '2022-03-31 17:07:30', NULL, '2A1123I292', '959133970614714374', '204');
INSERT INTO `tb_room` VALUES ('959136872259387406', '205', 0, '2022-03-31 17:07:30', NULL, '2A1123I293', '959133970614714374', '205');
INSERT INTO `tb_room` VALUES ('959136872259387407', '206', 0, '2022-03-31 17:07:30', NULL, '2A1123I294', '959133970614714374', '206');
INSERT INTO `tb_room` VALUES ('959136872259387408', '207', 0, '2022-03-31 17:07:30', NULL, '2A1123I295', '959133970614714374', '207');
INSERT INTO `tb_room` VALUES ('959136872259387409', '208', 0, '2022-03-31 17:07:30', NULL, '2A1123I296', '959133970614714374', '208');
INSERT INTO `tb_room` VALUES ('959136872259387410', '209', 0, '2022-03-31 17:07:30', NULL, '2A1123I297', '959133970614714374', '209');
INSERT INTO `tb_room` VALUES ('959136872259387411', '210', 0, '2022-03-31 17:07:30', NULL, '2A1123I298', '959133970614714374', '210');
INSERT INTO `tb_room` VALUES ('959136872259387412', '301', 0, '2022-03-31 17:07:30', NULL, '2A1123I299', '959133970614714374', '301');
INSERT INTO `tb_room` VALUES ('959136872259387413', '302', 0, '2022-03-31 17:07:30', NULL, '2A1123I3', '959133970614714374', '302');
INSERT INTO `tb_room` VALUES ('959136872259387414', '303', 0, '2022-03-31 17:07:30', NULL, '2A1123I30', '959133970614714374', '303');
INSERT INTO `tb_room` VALUES ('959136872259387415', '304', 0, '2022-03-31 17:07:30', NULL, '2A1123I300', '959133970614714374', '304');
INSERT INTO `tb_room` VALUES ('959136872259387416', '305', 0, '2022-03-31 17:07:30', NULL, '2A1123I301', '959133970614714374', '305');
INSERT INTO `tb_room` VALUES ('959136872259387417', '306', 0, '2022-03-31 17:07:30', NULL, '2A1123I302', '959133970614714374', '306');
INSERT INTO `tb_room` VALUES ('959136872259387418', '307', 0, '2022-03-31 17:07:30', NULL, '2A1123I303', '959133970614714374', '307');
INSERT INTO `tb_room` VALUES ('959136872259387419', '308', 0, '2022-03-31 17:07:30', NULL, '2A1123I304', '959133970614714374', '308');
INSERT INTO `tb_room` VALUES ('959136872259387420', '309', 0, '2022-03-31 17:07:30', NULL, '2A1123I305', '959133970614714374', '309');
INSERT INTO `tb_room` VALUES ('959136872259387421', '310', 0, '2022-03-31 17:07:30', NULL, '2A1123I306', '959133970614714374', '310');
INSERT INTO `tb_room` VALUES ('959136900633853952', '101', 0, '2022-03-31 17:07:37', NULL, '2A1123I307', '959133970614714375', '101');
INSERT INTO `tb_room` VALUES ('959136900633853953', '102', 0, '2022-03-31 17:07:37', NULL, '2A1123I308', '959133970614714375', '102');
INSERT INTO `tb_room` VALUES ('959136900633853954', '103', 0, '2022-03-31 17:07:37', NULL, '2A1123I309', '959133970614714375', '103');
INSERT INTO `tb_room` VALUES ('959136900633853955', '104', 0, '2022-03-31 17:07:37', NULL, '2A1123I31', '959133970614714375', '104');
INSERT INTO `tb_room` VALUES ('959136900633853956', '105', 0, '2022-03-31 17:07:37', NULL, '2A1123I310', '959133970614714375', '105');
INSERT INTO `tb_room` VALUES ('959136900633853957', '106', 0, '2022-03-31 17:07:37', NULL, '2A1123I311', '959133970614714375', '106');
INSERT INTO `tb_room` VALUES ('959136900633853958', '107', 0, '2022-03-31 17:07:37', NULL, '2A1123I312', '959133970614714375', '107');
INSERT INTO `tb_room` VALUES ('959136900633853959', '108', 0, '2022-03-31 17:07:37', NULL, '2A1123I313', '959133970614714375', '108');
INSERT INTO `tb_room` VALUES ('959136900633853960', '109', 0, '2022-03-31 17:07:37', NULL, '2A1123I314', '959133970614714375', '109');
INSERT INTO `tb_room` VALUES ('959136900633853961', '110', 0, '2022-03-31 17:07:37', NULL, '2A1123I315', '959133970614714375', '110');
INSERT INTO `tb_room` VALUES ('959136900633853962', '201', 0, '2022-03-31 17:07:37', NULL, '2A1123I316', '959133970614714375', '201');
INSERT INTO `tb_room` VALUES ('959136900633853963', '202', 0, '2022-03-31 17:07:37', NULL, '2A1123I317', '959133970614714375', '202');
INSERT INTO `tb_room` VALUES ('959136900633853964', '203', 0, '2022-03-31 17:07:37', NULL, '2A1123I318', '959133970614714375', '203');
INSERT INTO `tb_room` VALUES ('959136900633853965', '204', 0, '2022-03-31 17:07:37', NULL, '2A1123I319', '959133970614714375', '204');
INSERT INTO `tb_room` VALUES ('959136900633853966', '205', 0, '2022-03-31 17:07:37', NULL, '2A1123I32', '959133970614714375', '205');
INSERT INTO `tb_room` VALUES ('959136900633853967', '206', 0, '2022-03-31 17:07:37', NULL, '2A1123I320', '959133970614714375', '206');
INSERT INTO `tb_room` VALUES ('959136900633853968', '207', 0, '2022-03-31 17:07:37', NULL, '2A1123I321', '959133970614714375', '207');
INSERT INTO `tb_room` VALUES ('959136900633853969', '208', 0, '2022-03-31 17:07:37', NULL, '2A1123I322', '959133970614714375', '208');
INSERT INTO `tb_room` VALUES ('959136900633853970', '209', 0, '2022-03-31 17:07:37', NULL, '2A1123I323', '959133970614714375', '209');
INSERT INTO `tb_room` VALUES ('959136900633853971', '210', 0, '2022-03-31 17:07:37', NULL, '2A1123I324', '959133970614714375', '210');
INSERT INTO `tb_room` VALUES ('959136900633853972', '301', 0, '2022-03-31 17:07:37', NULL, '2A1123I325', '959133970614714375', '301');
INSERT INTO `tb_room` VALUES ('959136900633853973', '302', 0, '2022-03-31 17:07:37', NULL, '2A1123I326', '959133970614714375', '302');
INSERT INTO `tb_room` VALUES ('959136900633853974', '303', 0, '2022-03-31 17:07:37', NULL, '2A1123I327', '959133970614714375', '303');
INSERT INTO `tb_room` VALUES ('959136900633853975', '304', 0, '2022-03-31 17:07:37', NULL, '2A1123I328', '959133970614714375', '304');
INSERT INTO `tb_room` VALUES ('959136900633853976', '305', 0, '2022-03-31 17:07:37', NULL, '2A1123I329', '959133970614714375', '305');
INSERT INTO `tb_room` VALUES ('959136900633853977', '306', 0, '2022-03-31 17:07:37', NULL, '2A1123I33', '959133970614714375', '306');
INSERT INTO `tb_room` VALUES ('959136900633853978', '307', 0, '2022-03-31 17:07:37', NULL, '2A1123I330', '959133970614714375', '307');
INSERT INTO `tb_room` VALUES ('959136900633853979', '308', 0, '2022-03-31 17:07:37', NULL, '2A1123I331', '959133970614714375', '308');
INSERT INTO `tb_room` VALUES ('959136900633853980', '309', 0, '2022-03-31 17:07:37', NULL, '2A1123I332', '959133970614714375', '309');
INSERT INTO `tb_room` VALUES ('959136900638048256', '310', 0, '2022-03-31 17:07:37', NULL, '2A1123I333', '959133970614714375', '310');
INSERT INTO `tb_room` VALUES ('962015769904807936', '101', 0, '2022-04-08 15:47:13', NULL, '2A1123I361', '959134190484324352', '101');
INSERT INTO `tb_room` VALUES ('962015769904807937', '102', 0, '2022-04-08 15:47:13', NULL, '2A1123I362', '959134190484324352', '102');
INSERT INTO `tb_room` VALUES ('962015769904807938', '103', 0, '2022-04-08 15:47:13', NULL, '2A1123I363', '959134190484324352', '103');
INSERT INTO `tb_room` VALUES ('962015769904807939', '104', 0, '2022-04-08 15:47:13', NULL, '2A1123I364', '959134190484324352', '104');
INSERT INTO `tb_room` VALUES ('962015769904807940', '105', 0, '2022-04-08 15:47:13', NULL, '2A1123I365', '959134190484324352', '105');
INSERT INTO `tb_room` VALUES ('962015769904807941', '106', 0, '2022-04-08 15:47:13', NULL, '2A1123I366', '959134190484324352', '106');
INSERT INTO `tb_room` VALUES ('962015769904807942', '107', 0, '2022-04-08 15:47:13', NULL, '2A1123I367', '959134190484324352', '107');
INSERT INTO `tb_room` VALUES ('962015769904807943', '108', 0, '2022-04-08 15:47:13', NULL, '2A1123I368', '959134190484324352', '108');
INSERT INTO `tb_room` VALUES ('962015769904807944', '109', 0, '2022-04-08 15:47:13', NULL, '2A1123I369', '959134190484324352', '109');
INSERT INTO `tb_room` VALUES ('962015769904807945', '110', 0, '2022-04-08 15:47:13', NULL, '2A1123I37', '959134190484324352', '110');
INSERT INTO `tb_room` VALUES ('962015769904807946', '201', 0, '2022-04-08 15:47:13', NULL, '2A1123I370', '959134190484324352', '201');
INSERT INTO `tb_room` VALUES ('962015769909002240', '202', 0, '2022-04-08 15:47:13', NULL, '2A1123I371', '959134190484324352', '202');
INSERT INTO `tb_room` VALUES ('962015769909002241', '203', 0, '2022-04-08 15:47:13', NULL, '2A1123I372', '959134190484324352', '203');
INSERT INTO `tb_room` VALUES ('962015769909002242', '204', 0, '2022-04-08 15:47:13', NULL, '2A1123I373', '959134190484324352', '204');
INSERT INTO `tb_room` VALUES ('962015769909002243', '205', 0, '2022-04-08 15:47:13', NULL, '2A1123I374', '959134190484324352', '205');
INSERT INTO `tb_room` VALUES ('962015769909002244', '206', 0, '2022-04-08 15:47:13', NULL, '2A1123I375', '959134190484324352', '206');
INSERT INTO `tb_room` VALUES ('962015769909002245', '207', 0, '2022-04-08 15:47:13', NULL, '2A1123I376', '959134190484324352', '207');
INSERT INTO `tb_room` VALUES ('962015769909002246', '208', 0, '2022-04-08 15:47:13', NULL, '2A1123I377', '959134190484324352', '208');
INSERT INTO `tb_room` VALUES ('962015769909002247', '209', 0, '2022-04-08 15:47:13', NULL, '2A1123I378', '959134190484324352', '209');
INSERT INTO `tb_room` VALUES ('962015769909002248', '210', 0, '2022-04-08 15:47:13', NULL, '2A1123I379', '959134190484324352', '210');
INSERT INTO `tb_room` VALUES ('962015817627598848', '101', 0, '2022-04-08 15:47:24', NULL, '2A1123I46', '959134190484324353', '101');
INSERT INTO `tb_room` VALUES ('962015817627598849', '102', 0, '2022-04-08 15:47:24', NULL, '2A1123I47', '959134190484324353', '102');
INSERT INTO `tb_room` VALUES ('962015817627598850', '103', 0, '2022-04-08 15:47:24', NULL, '2A1123I48', '959134190484324353', '103');
INSERT INTO `tb_room` VALUES ('962015817627598851', '104', 0, '2022-04-08 15:47:24', NULL, '2A1123I49', '959134190484324353', '104');
INSERT INTO `tb_room` VALUES ('962015817627598852', '105', 0, '2022-04-08 15:47:24', NULL, '2A1123I5', '959134190484324353', '105');
INSERT INTO `tb_room` VALUES ('962015817627598853', '106', 0, '2022-04-08 15:47:24', NULL, '2A1123I50', '959134190484324353', '106');
INSERT INTO `tb_room` VALUES ('962015817627598854', '107', 0, '2022-04-08 15:47:24', NULL, '2A1123I51', '959134190484324353', '107');
INSERT INTO `tb_room` VALUES ('962015817627598855', '108', 0, '2022-04-08 15:47:24', NULL, '2A1123I52', '959134190484324353', '108');
INSERT INTO `tb_room` VALUES ('962015817627598856', '109', 0, '2022-04-08 15:47:24', NULL, '2A1123I53', '959134190484324353', '109');
INSERT INTO `tb_room` VALUES ('962015817627598857', '110', 0, '2022-04-08 15:47:24', NULL, '2A1123I54', '959134190484324353', '110');
INSERT INTO `tb_room` VALUES ('962015817627598858', '201', 0, '2022-04-08 15:47:24', NULL, '2A1123I55', '959134190484324353', '201');
INSERT INTO `tb_room` VALUES ('962015817627598859', '202', 0, '2022-04-08 15:47:24', NULL, '2A1123I56', '959134190484324353', '202');
INSERT INTO `tb_room` VALUES ('962015817627598860', '203', 0, '2022-04-08 15:47:24', NULL, '2A1123I57', '959134190484324353', '203');
INSERT INTO `tb_room` VALUES ('962015817627598861', '204', 0, '2022-04-08 15:47:24', NULL, '2A1123I58', '959134190484324353', '204');
INSERT INTO `tb_room` VALUES ('962015817627598862', '205', 0, '2022-04-08 15:47:24', NULL, '2A1123I59', '959134190484324353', '205');
INSERT INTO `tb_room` VALUES ('962015817627598863', '206', 0, '2022-04-08 15:47:24', NULL, '2A1123I6', '959134190484324353', '206');
INSERT INTO `tb_room` VALUES ('962015817627598864', '207', 0, '2022-04-08 15:47:24', NULL, '2A1123I60', '959134190484324353', '207');
INSERT INTO `tb_room` VALUES ('962015817627598865', '208', 0, '2022-04-08 15:47:24', NULL, '2A1123I61', '959134190484324353', '208');
INSERT INTO `tb_room` VALUES ('962015817627598866', '209', 0, '2022-04-08 15:47:24', NULL, '2A1123I62', '959134190484324353', '209');
INSERT INTO `tb_room` VALUES ('962015817627598867', '210', 0, '2022-04-08 15:47:24', NULL, '2A1123I63', '959134190484324353', '210');
INSERT INTO `tb_room` VALUES ('962015864775770112', '101', 0, '2022-04-08 15:47:36', NULL, '2A1123I91', '959134190484324354', '101');
INSERT INTO `tb_room` VALUES ('962015864775770113', '102', 0, '2022-04-08 15:47:36', NULL, '2A1123I92', '959134190484324354', '102');
INSERT INTO `tb_room` VALUES ('962015864775770114', '103', 0, '2022-04-08 15:47:36', NULL, '2A1123I93', '959134190484324354', '103');
INSERT INTO `tb_room` VALUES ('962015864775770115', '104', 0, '2022-04-08 15:47:36', NULL, '2A1123I94', '959134190484324354', '104');
INSERT INTO `tb_room` VALUES ('962015864775770116', '105', 0, '2022-04-08 15:47:36', NULL, '2A1123I95', '959134190484324354', '105');
INSERT INTO `tb_room` VALUES ('962015864775770117', '106', 0, '2022-04-08 15:47:36', NULL, '2A1123I96', '959134190484324354', '106');
INSERT INTO `tb_room` VALUES ('962015864775770118', '107', 0, '2022-04-08 15:47:36', NULL, '2A1123I97', '959134190484324354', '107');
INSERT INTO `tb_room` VALUES ('962015864775770119', '108', 0, '2022-04-08 15:47:36', NULL, '2A1123I98', '959134190484324354', '108');
INSERT INTO `tb_room` VALUES ('962015864775770120', '109', 0, '2022-04-08 15:47:36', NULL, '2A1123I99', '959134190484324354', '109');
INSERT INTO `tb_room` VALUES ('962015864775770121', '110', 0, '2022-04-08 15:47:36', NULL, '2A1123J1', '959134190484324354', '110');
INSERT INTO `tb_room` VALUES ('962015864775770122', '201', 0, '2022-04-08 15:47:36', NULL, '2A1123J10', '959134190484324354', '201');
INSERT INTO `tb_room` VALUES ('962015864775770123', '202', 0, '2022-04-08 15:47:36', NULL, '2A1123J11', '959134190484324354', '202');
INSERT INTO `tb_room` VALUES ('962015864775770124', '203', 0, '2022-04-08 15:47:36', NULL, '2A1123J12', '959134190484324354', '203');
INSERT INTO `tb_room` VALUES ('962015864775770125', '204', 0, '2022-04-08 15:47:36', NULL, '2A1123J13', '959134190484324354', '204');
INSERT INTO `tb_room` VALUES ('962015864775770126', '205', 0, '2022-04-08 15:47:36', NULL, '2A1123J14', '959134190484324354', '205');
INSERT INTO `tb_room` VALUES ('962015864779964416', '206', 0, '2022-04-08 15:47:36', NULL, '2A1123J15', '959134190484324354', '206');
INSERT INTO `tb_room` VALUES ('962015864779964417', '207', 0, '2022-04-08 15:47:36', NULL, '2A1123J16', '959134190484324354', '207');
INSERT INTO `tb_room` VALUES ('962015864779964418', '208', 0, '2022-04-08 15:47:36', NULL, '2A1123J17', '959134190484324354', '208');
INSERT INTO `tb_room` VALUES ('962015864779964419', '209', 0, '2022-04-08 15:47:36', NULL, '2A1123J18', '959134190484324354', '209');
INSERT INTO `tb_room` VALUES ('962015864779964420', '210', 0, '2022-04-08 15:47:36', NULL, '2A1123J19', '959134190484324354', '210');
INSERT INTO `tb_room` VALUES ('962015905800257536', '101', 0, '2022-04-08 15:47:45', NULL, '2A1123J47', '959134190484324355', '101');
INSERT INTO `tb_room` VALUES ('962015905800257537', '102', 0, '2022-04-08 15:47:45', NULL, '2A1123J48', '959134190484324355', '102');
INSERT INTO `tb_room` VALUES ('962015905800257538', '103', 0, '2022-04-08 15:47:45', NULL, '2A1123J49', '959134190484324355', '103');
INSERT INTO `tb_room` VALUES ('962015905800257539', '104', 0, '2022-04-08 15:47:45', NULL, '2A1123J5', '959134190484324355', '104');
INSERT INTO `tb_room` VALUES ('962015905800257540', '105', 0, '2022-04-08 15:47:45', NULL, '2A1123J50', '959134190484324355', '105');
INSERT INTO `tb_room` VALUES ('962015905800257541', '106', 0, '2022-04-08 15:47:45', NULL, '2A1123J51', '959134190484324355', '106');
INSERT INTO `tb_room` VALUES ('962015905800257542', '107', 0, '2022-04-08 15:47:45', NULL, '2A1123J52', '959134190484324355', '107');
INSERT INTO `tb_room` VALUES ('962015905800257543', '108', 0, '2022-04-08 15:47:45', NULL, '2A1123J53', '959134190484324355', '108');
INSERT INTO `tb_room` VALUES ('962015905800257544', '109', 0, '2022-04-08 15:47:45', NULL, '2A1123J54', '959134190484324355', '109');
INSERT INTO `tb_room` VALUES ('962015905800257545', '110', 0, '2022-04-08 15:47:45', NULL, '2A1123J55', '959134190484324355', '110');
INSERT INTO `tb_room` VALUES ('962015905804451840', '201', 0, '2022-04-08 15:47:45', NULL, '2A1123J56', '959134190484324355', '201');
INSERT INTO `tb_room` VALUES ('962015905804451841', '202', 0, '2022-04-08 15:47:45', NULL, '2A1123J57', '959134190484324355', '202');
INSERT INTO `tb_room` VALUES ('962015905804451842', '203', 0, '2022-04-08 15:47:45', NULL, '2A1123J58', '959134190484324355', '203');
INSERT INTO `tb_room` VALUES ('962015905804451843', '204', 0, '2022-04-08 15:47:45', NULL, '2A1123J59', '959134190484324355', '204');
INSERT INTO `tb_room` VALUES ('962015905804451844', '205', 0, '2022-04-08 15:47:45', NULL, '2A1123J6', '959134190484324355', '205');
INSERT INTO `tb_room` VALUES ('962015905804451845', '206', 0, '2022-04-08 15:47:45', NULL, '2A1123J60', '959134190484324355', '206');
INSERT INTO `tb_room` VALUES ('962015905804451846', '207', 0, '2022-04-08 15:47:45', NULL, '2A1123J61', '959134190484324355', '207');
INSERT INTO `tb_room` VALUES ('962015905804451847', '208', 0, '2022-04-08 15:47:45', NULL, '2A1123J7', '959134190484324355', '208');
INSERT INTO `tb_room` VALUES ('962015905804451848', '209', 0, '2022-04-08 15:47:45', NULL, '2A1123J8', '959134190484324355', '209');
INSERT INTO `tb_room` VALUES ('962015905804451849', '210', 0, '2022-04-08 15:47:45', NULL, '2A1123J9', '959134190484324355', '210');
INSERT INTO `tb_room` VALUES ('962016296973631488', '101', 0, '2022-04-08 15:49:19', NULL, '1h2481jf152fg', '904783914302701569', '101');
INSERT INTO `tb_room` VALUES ('962016296973631489', '102', 0, '2022-04-08 15:49:19', NULL, '2A1123H100', '904783914302701569', '102');
INSERT INTO `tb_room` VALUES ('962016296973631490', '103', 0, '2022-04-08 15:49:19', NULL, '2A1123H23', '904783914302701569', '103');
INSERT INTO `tb_room` VALUES ('962016296973631491', '104', 0, '2022-04-08 15:49:19', NULL, '2A1123H24', '904783914302701569', '104');
INSERT INTO `tb_room` VALUES ('962016296973631492', '105', 0, '2022-04-08 15:49:19', NULL, '2A1123H25', '904783914302701569', '105');
INSERT INTO `tb_room` VALUES ('962016296973631493', '106', 0, '2022-04-08 15:49:19', NULL, '2A1123H26', '904783914302701569', '106');
INSERT INTO `tb_room` VALUES ('962016296977825792', '107', 0, '2022-04-08 15:49:19', NULL, '2A1123H27', '904783914302701569', '107');
INSERT INTO `tb_room` VALUES ('962016296977825793', '108', 0, '2022-04-08 15:49:19', NULL, '2A1123H28', '904783914302701569', '108');
INSERT INTO `tb_room` VALUES ('962016296977825794', '109', 0, '2022-04-08 15:49:19', NULL, '2A1123H29', '904783914302701569', '109');
INSERT INTO `tb_room` VALUES ('962016296977825795', '110', 0, '2022-04-08 15:49:19', NULL, '2A1123H30', '904783914302701569', '110');
INSERT INTO `tb_room` VALUES ('962016296977825796', '201', 0, '2022-04-08 15:49:19', NULL, '2A1123H31', '904783914302701569', '201');
INSERT INTO `tb_room` VALUES ('962016296977825797', '202', 0, '2022-04-08 15:49:19', NULL, '2A1123H32', '904783914302701569', '202');
INSERT INTO `tb_room` VALUES ('962016296977825798', '203', 0, '2022-04-08 15:49:19', NULL, '2A1123H33', '904783914302701569', '203');
INSERT INTO `tb_room` VALUES ('962016296977825799', '204', 0, '2022-04-08 15:49:19', NULL, '2A1123H34', '904783914302701569', '204');
INSERT INTO `tb_room` VALUES ('962016296977825800', '205', 0, '2022-04-08 15:49:19', NULL, '2A1123H35', '904783914302701569', '205');
INSERT INTO `tb_room` VALUES ('962016296977825801', '206', 0, '2022-04-08 15:49:19', NULL, '2A1123H36', '904783914302701569', '206');
INSERT INTO `tb_room` VALUES ('962016296977825802', '207', 0, '2022-04-08 15:49:19', NULL, '2A1123H37', '904783914302701569', '207');
INSERT INTO `tb_room` VALUES ('962016296977825803', '208', 0, '2022-04-08 15:49:19', NULL, '2A1123H38', '904783914302701569', '208');
INSERT INTO `tb_room` VALUES ('962016296977825804', '209', 0, '2022-04-08 15:49:19', NULL, '2A1123H39', '904783914302701569', '209');
INSERT INTO `tb_room` VALUES ('962016296977825805', '210', 0, '2022-04-08 15:49:19', NULL, '2A1123H40', '904783914302701569', '210');
INSERT INTO `tb_room` VALUES ('962016342238560256', '101', 0, '2022-04-08 15:49:29', NULL, '2A1123H41', '904783914302701570', '101');
INSERT INTO `tb_room` VALUES ('962016342238560257', '102', 0, '2022-04-08 15:49:29', NULL, '2A1123H42', '904783914302701570', '102');
INSERT INTO `tb_room` VALUES ('962016342238560258', '103', 0, '2022-04-08 15:49:29', NULL, '2A1123H43', '904783914302701570', '103');
INSERT INTO `tb_room` VALUES ('962016342238560259', '104', 0, '2022-04-08 15:49:29', NULL, '2A1123H44', '904783914302701570', '104');
INSERT INTO `tb_room` VALUES ('962016342238560260', '105', 0, '2022-04-08 15:49:29', NULL, '2A1123H45', '904783914302701570', '105');
INSERT INTO `tb_room` VALUES ('962016342238560261', '106', 0, '2022-04-08 15:49:29', NULL, '2A1123H46', '904783914302701570', '106');
INSERT INTO `tb_room` VALUES ('962016342238560262', '107', 0, '2022-04-08 15:49:29', NULL, '2A1123H47', '904783914302701570', '107');
INSERT INTO `tb_room` VALUES ('962016342238560263', '108', 0, '2022-04-08 15:49:29', NULL, '2A1123H48', '904783914302701570', '108');
INSERT INTO `tb_room` VALUES ('962016342238560264', '109', 0, '2022-04-08 15:49:29', NULL, '2A1123H49', '904783914302701570', '109');
INSERT INTO `tb_room` VALUES ('962016342238560265', '110', 0, '2022-04-08 15:49:29', NULL, '2A1123H50', '904783914302701570', '110');
INSERT INTO `tb_room` VALUES ('962016342238560266', '201', 0, '2022-04-08 15:49:29', NULL, '2A1123H51', '904783914302701570', '201');
INSERT INTO `tb_room` VALUES ('962016342238560267', '202', 0, '2022-04-08 15:49:29', NULL, '2A1123H52', '904783914302701570', '202');
INSERT INTO `tb_room` VALUES ('962016342238560268', '203', 0, '2022-04-08 15:49:29', NULL, '2A1123H53', '904783914302701570', '203');
INSERT INTO `tb_room` VALUES ('962016342238560269', '204', 0, '2022-04-08 15:49:29', NULL, '2A1123H54', '904783914302701570', '204');
INSERT INTO `tb_room` VALUES ('962016342238560270', '205', 0, '2022-04-08 15:49:29', NULL, '2A1123H55', '904783914302701570', '205');
INSERT INTO `tb_room` VALUES ('962016342238560271', '206', 0, '2022-04-08 15:49:29', NULL, '2A1123H56', '904783914302701570', '206');
INSERT INTO `tb_room` VALUES ('962016342238560272', '207', 0, '2022-04-08 15:49:29', NULL, '2A1123H57', '904783914302701570', '207');
INSERT INTO `tb_room` VALUES ('962016342238560273', '208', 0, '2022-04-08 15:49:29', NULL, '2A1123H58', '904783914302701570', '208');
INSERT INTO `tb_room` VALUES ('962016342238560274', '209', 0, '2022-04-08 15:49:29', NULL, '2A1123H59', '904783914302701570', '209');
INSERT INTO `tb_room` VALUES ('962016342238560275', '210', 0, '2022-04-08 15:49:29', NULL, '2A1123H60', '904783914302701570', '210');
INSERT INTO `tb_room` VALUES ('962016377168723968', '101', 0, '2022-04-08 15:49:38', NULL, '2A1123H61', '904783914302701571', '101');
INSERT INTO `tb_room` VALUES ('962016377168723969', '102', 0, '2022-04-08 15:49:38', NULL, '2A1123H62', '904783914302701571', '102');
INSERT INTO `tb_room` VALUES ('962016377168723970', '103', 0, '2022-04-08 15:49:38', NULL, '2A1123H63', '904783914302701571', '103');
INSERT INTO `tb_room` VALUES ('962016377168723971', '104', 0, '2022-04-08 15:49:38', NULL, '2A1123H64', '904783914302701571', '104');
INSERT INTO `tb_room` VALUES ('962016377168723972', '105', 0, '2022-04-08 15:49:38', NULL, '2A1123H65', '904783914302701571', '105');
INSERT INTO `tb_room` VALUES ('962016377168723973', '106', 0, '2022-04-08 15:49:38', NULL, '2A1123H66', '904783914302701571', '106');
INSERT INTO `tb_room` VALUES ('962016377168723974', '107', 0, '2022-04-08 15:49:38', NULL, '2A1123H67', '904783914302701571', '107');
INSERT INTO `tb_room` VALUES ('962016377168723975', '108', 0, '2022-04-08 15:49:38', NULL, '2A1123H68', '904783914302701571', '108');
INSERT INTO `tb_room` VALUES ('962016377168723976', '109', 0, '2022-04-08 15:49:38', NULL, '2A1123H69', '904783914302701571', '109');
INSERT INTO `tb_room` VALUES ('962016377168723977', '110', 0, '2022-04-08 15:49:38', NULL, '2A1123H70', '904783914302701571', '110');
INSERT INTO `tb_room` VALUES ('962016377168723978', '201', 0, '2022-04-08 15:49:38', NULL, '2A1123H71', '904783914302701571', '201');
INSERT INTO `tb_room` VALUES ('962016377168723979', '202', 0, '2022-04-08 15:49:38', NULL, '2A1123H72', '904783914302701571', '202');
INSERT INTO `tb_room` VALUES ('962016377168723980', '203', 0, '2022-04-08 15:49:38', NULL, '2A1123H73', '904783914302701571', '203');
INSERT INTO `tb_room` VALUES ('962016377168723981', '204', 0, '2022-04-08 15:49:38', NULL, '2A1123H74', '904783914302701571', '204');
INSERT INTO `tb_room` VALUES ('962016377168723982', '205', 0, '2022-04-08 15:49:38', NULL, '2A1123H75', '904783914302701571', '205');
INSERT INTO `tb_room` VALUES ('962016377168723983', '206', 0, '2022-04-08 15:49:38', NULL, '2A1123H76', '904783914302701571', '206');
INSERT INTO `tb_room` VALUES ('962016377172918272', '207', 0, '2022-04-08 15:49:38', NULL, '2A1123H77', '904783914302701571', '207');
INSERT INTO `tb_room` VALUES ('962016377172918273', '208', 0, '2022-04-08 15:49:38', NULL, '2A1123H78', '904783914302701571', '208');
INSERT INTO `tb_room` VALUES ('962016377172918274', '209', 0, '2022-04-08 15:49:38', NULL, '2A1123H79', '904783914302701571', '209');
INSERT INTO `tb_room` VALUES ('962016377172918275', '210', 0, '2022-04-08 15:49:38', NULL, '2A1123H80', '904783914302701571', '210');
INSERT INTO `tb_room` VALUES ('962016407992664064', '101', 0, '2022-04-08 15:49:45', NULL, '2A1123H81', '904783914302701572', '101');
INSERT INTO `tb_room` VALUES ('962016407992664065', '102', 0, '2022-04-08 15:49:45', NULL, '2A1123H82', '904783914302701572', '102');
INSERT INTO `tb_room` VALUES ('962016407992664066', '103', 0, '2022-04-08 15:49:45', NULL, '2A1123H83', '904783914302701572', '103');
INSERT INTO `tb_room` VALUES ('962016407992664067', '104', 0, '2022-04-08 15:49:45', NULL, '2A1123H84', '904783914302701572', '104');
INSERT INTO `tb_room` VALUES ('962016407992664068', '105', 0, '2022-04-08 15:49:45', NULL, '2A1123H85', '904783914302701572', '105');
INSERT INTO `tb_room` VALUES ('962016407992664069', '106', 0, '2022-04-08 15:49:45', NULL, '2A1123H86', '904783914302701572', '106');
INSERT INTO `tb_room` VALUES ('962016407992664070', '107', 0, '2022-04-08 15:49:45', NULL, '2A1123H87', '904783914302701572', '107');
INSERT INTO `tb_room` VALUES ('962016407992664071', '108', 0, '2022-04-08 15:49:45', NULL, '2A1123H88', '904783914302701572', '108');
INSERT INTO `tb_room` VALUES ('962016407992664072', '109', 0, '2022-04-08 15:49:45', NULL, '2A1123H89', '904783914302701572', '109');
INSERT INTO `tb_room` VALUES ('962016407992664073', '110', 0, '2022-04-08 15:49:45', NULL, '2A1123H90', '904783914302701572', '110');
INSERT INTO `tb_room` VALUES ('962016407992664074', '201', 0, '2022-04-08 15:49:45', NULL, '2A1123H91', '904783914302701572', '201');
INSERT INTO `tb_room` VALUES ('962016407992664075', '202', 0, '2022-04-08 15:49:45', NULL, '2A1123H92', '904783914302701572', '202');
INSERT INTO `tb_room` VALUES ('962016407992664076', '203', 0, '2022-04-08 15:49:45', NULL, '2A1123H93', '904783914302701572', '203');
INSERT INTO `tb_room` VALUES ('962016407992664077', '204', 0, '2022-04-08 15:49:45', NULL, '2A1123H94', '904783914302701572', '204');
INSERT INTO `tb_room` VALUES ('962016407992664078', '205', 0, '2022-04-08 15:49:45', NULL, '2A1123H95', '904783914302701572', '205');
INSERT INTO `tb_room` VALUES ('962016407992664079', '206', 0, '2022-04-08 15:49:45', NULL, '2A1123H96', '904783914302701572', '206');
INSERT INTO `tb_room` VALUES ('962016407992664080', '207', 0, '2022-04-08 15:49:45', NULL, '2A1123H97', '904783914302701572', '207');
INSERT INTO `tb_room` VALUES ('962016407992664081', '208', 0, '2022-04-08 15:49:45', NULL, '2A1123H98', '904783914302701572', '208');
INSERT INTO `tb_room` VALUES ('962016407992664082', '209', 0, '2022-04-08 15:49:45', NULL, '2A1123H99', '904783914302701572', '209');
INSERT INTO `tb_room` VALUES ('962016407992664083', '210', 0, '2022-04-08 15:49:45', NULL, '2A1123I1', '904783914302701572', '210');
INSERT INTO `tb_room` VALUES ('962016452339040256', '101', 0, '2022-04-08 15:49:56', NULL, '2A1123I10', '904783914302701573', '101');
INSERT INTO `tb_room` VALUES ('962016452339040257', '102', 0, '2022-04-08 15:49:56', NULL, '2A1123I100', '904783914302701573', '102');
INSERT INTO `tb_room` VALUES ('962016452339040258', '103', 0, '2022-04-08 15:49:56', NULL, '2A1123I101', '904783914302701573', '103');
INSERT INTO `tb_room` VALUES ('962016452339040259', '104', 0, '2022-04-08 15:49:56', NULL, '2A1123I102', '904783914302701573', '104');
INSERT INTO `tb_room` VALUES ('962016452339040260', '105', 0, '2022-04-08 15:49:56', NULL, '2A1123I103', '904783914302701573', '105');
INSERT INTO `tb_room` VALUES ('962016452339040261', '106', 0, '2022-04-08 15:49:56', NULL, '2A1123I104', '904783914302701573', '106');
INSERT INTO `tb_room` VALUES ('962016452339040262', '107', 0, '2022-04-08 15:49:56', NULL, '2A1123I105', '904783914302701573', '107');
INSERT INTO `tb_room` VALUES ('962016452339040263', '108', 0, '2022-04-08 15:49:56', NULL, '2A1123I106', '904783914302701573', '108');
INSERT INTO `tb_room` VALUES ('962016452339040264', '109', 0, '2022-04-08 15:49:56', NULL, '2A1123I107', '904783914302701573', '109');
INSERT INTO `tb_room` VALUES ('962016452339040265', '110', 0, '2022-04-08 15:49:56', NULL, '2A1123I108', '904783914302701573', '110');
INSERT INTO `tb_room` VALUES ('962016452339040266', '201', 0, '2022-04-08 15:49:56', NULL, '2A1123I109', '904783914302701573', '201');
INSERT INTO `tb_room` VALUES ('962016452339040267', '202', 0, '2022-04-08 15:49:56', NULL, '2A1123I11', '904783914302701573', '202');
INSERT INTO `tb_room` VALUES ('962016452339040268', '203', 0, '2022-04-08 15:49:56', NULL, '2A1123I110', '904783914302701573', '203');
INSERT INTO `tb_room` VALUES ('962016452339040269', '204', 0, '2022-04-08 15:49:56', NULL, '2A1123I111', '904783914302701573', '204');
INSERT INTO `tb_room` VALUES ('962016452339040270', '205', 0, '2022-04-08 15:49:56', NULL, '2A1123I112', '904783914302701573', '205');
INSERT INTO `tb_room` VALUES ('962016452339040271', '206', 0, '2022-04-08 15:49:56', NULL, '2A1123I113', '904783914302701573', '206');
INSERT INTO `tb_room` VALUES ('962016452339040272', '207', 0, '2022-04-08 15:49:56', NULL, '2A1123I114', '904783914302701573', '207');
INSERT INTO `tb_room` VALUES ('962016452339040273', '208', 0, '2022-04-08 15:49:56', NULL, '2A1123I115', '904783914302701573', '208');
INSERT INTO `tb_room` VALUES ('962016452339040274', '209', 0, '2022-04-08 15:49:56', NULL, '2A1123I116', '904783914302701573', '209');
INSERT INTO `tb_room` VALUES ('962016452339040275', '210', 0, '2022-04-08 15:49:56', NULL, '2A1123I117', '904783914302701573', '210');
INSERT INTO `tb_room` VALUES ('970691947393974272', '1A101', 0, '2022-05-02 14:23:15', '2022-05-02 14:23:15', '2a2s23', '970691118645641216', '1A101');
INSERT INTO `tb_room` VALUES ('970692085248163840', '1A102', 0, '2022-05-02 14:23:48', '2022-05-02 14:23:48', '2a2s24', '970691118645641216', '1A102');
INSERT INTO `tb_room` VALUES ('970692190252564480', '2A101', 0, '2022-05-02 14:24:13', '2022-05-02 14:24:13', '2a2s25', '970691204876337152', '1A101');
INSERT INTO `tb_room` VALUES ('970692241263689728', '2A102', 0, '2022-05-02 14:24:25', '2022-05-02 14:24:25', '2a2s26', '970691204876337152', '1A102');
COMMIT;

-- ----------------------------
-- Table structure for tb_room_degree
-- ----------------------------
DROP TABLE IF EXISTS `tb_room_degree`;
CREATE TABLE `tb_room_degree` (
  `room_id` varchar(200) NOT NULL COMMENT '房间id',
  `equipment_identifier` varchar(200) NOT NULL COMMENT '设备id',
  `degree` decimal(10,8) DEFAULT NULL COMMENT '电量数',
  `time` datetime NOT NULL COMMENT '日期',
  PRIMARY KEY (`equipment_identifier`,`time`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tb_room_degree
-- ----------------------------
BEGIN;
INSERT INTO `tb_room_degree` VALUES ('962016452339040264', '2A1123I107', 10.62000000, '2022-04-27 14:08:27');
INSERT INTO `tb_room_degree` VALUES ('962016452339040264', '2A1123I107', 10.92000000, '2022-04-28 02:08:27');
INSERT INTO `tb_room_degree` VALUES ('962016452339040264', '2A1123I107', 11.02000000, '2022-04-29 02:08:27');
INSERT INTO `tb_room_degree` VALUES ('962016452339040264', '2A1123I107', 12.02000000, '2022-04-30 02:08:27');
INSERT INTO `tb_room_degree` VALUES ('962016452339040264', '2A1123I107', 14.02000000, '2022-05-01 02:08:27');
INSERT INTO `tb_room_degree` VALUES ('962016452339040264', '2A1123I107', 15.02000000, '2022-05-05 02:08:27');
INSERT INTO `tb_room_degree` VALUES ('959136569027985408', '2A1123I334', 20.00000000, '2022-01-01 16:17:00');
INSERT INTO `tb_room_degree` VALUES ('959136569027985408', '2A1123I334', 20.00000000, '2022-02-01 16:17:00');
INSERT INTO `tb_room_degree` VALUES ('959136569027985408', '2A1123I334', 20.00000000, '2022-03-01 16:17:00');
INSERT INTO `tb_room_degree` VALUES ('959136569027985408', '2A1123I334', 22.00000000, '2022-04-30 16:17:00');
INSERT INTO `tb_room_degree` VALUES ('959136569027985408', '2A1123I334', 23.01200000, '2022-05-01 16:17:00');
INSERT INTO `tb_room_degree` VALUES ('959136569027985408', '2A1123I334', 20.00000000, '2022-06-01 16:17:00');
INSERT INTO `tb_room_degree` VALUES ('959136569027985408', '2A1123I334', 20.00000000, '2022-07-01 16:17:00');
INSERT INTO `tb_room_degree` VALUES ('959136569027985408', '2A1123I334', 20.00000000, '2022-08-01 16:17:00');
INSERT INTO `tb_room_degree` VALUES ('959136569027985408', '2A1123I334', 20.00000000, '2022-09-01 16:17:00');
INSERT INTO `tb_room_degree` VALUES ('959136569027985408', '2A1123I334', 20.00000000, '2022-10-01 16:17:00');
INSERT INTO `tb_room_degree` VALUES ('959136569027985408', '2A1123I334', 20.00000000, '2022-11-01 16:17:00');
INSERT INTO `tb_room_degree` VALUES ('959136569027985408', '2A1123I334', 20.00000000, '2022-12-01 16:17:00');
INSERT INTO `tb_room_degree` VALUES ('959136569053151232', '2A1123I335', 28.02300000, '2022-05-01 16:52:06');
INSERT INTO `tb_room_degree` VALUES ('959136569053151232', '2A1123I335', 29.02300000, '2022-05-02 16:52:06');
INSERT INTO `tb_room_degree` VALUES ('959136569053151232', '2A1123I335', 30.02300000, '2022-05-03 16:52:06');
INSERT INTO `tb_room_degree` VALUES ('959136569053151232', '2A1123I335', 30.52300000, '2022-05-04 16:52:06');
INSERT INTO `tb_room_degree` VALUES ('959136569053151232', '2A1123I335', 31.02300000, '2022-05-05 16:52:06');
INSERT INTO `tb_room_degree` VALUES ('970691947393974272', '2a2s23', 15.02000000, '2022-04-05 02:08:27');
INSERT INTO `tb_room_degree` VALUES ('970691947393974272', '2a2s23', 14.02000000, '2022-04-06 02:08:27');
INSERT INTO `tb_room_degree` VALUES ('970691947393974272', '2a2s23', 19.02000000, '2022-04-07 02:08:27');
INSERT INTO `tb_room_degree` VALUES ('970691947393974272', '2a2s23', 22.02000000, '2022-05-10 02:08:27');
INSERT INTO `tb_room_degree` VALUES ('970692085248163840', '2a2s24', 22.02000000, '2022-04-10 02:08:27');
INSERT INTO `tb_room_degree` VALUES ('970692085248163840', '2a2s24', 25.02000000, '2022-04-12 02:08:27');
INSERT INTO `tb_room_degree` VALUES ('970692085248163840', '2a2s24', 30.02000000, '2022-05-01 02:08:27');
INSERT INTO `tb_room_degree` VALUES ('970692190252564480', '2a2s25', 10.02000000, '2022-04-01 02:08:27');
INSERT INTO `tb_room_degree` VALUES ('970692190252564480', '2a2s25', 17.02000000, '2022-04-10 02:08:27');
INSERT INTO `tb_room_degree` VALUES ('970692190252564480', '2a2s25', 24.02000000, '2022-04-20 02:08:27');
INSERT INTO `tb_room_degree` VALUES ('970692190252564480', '2a2s25', 24.02000000, '2022-05-20 02:08:27');
INSERT INTO `tb_room_degree` VALUES ('970692241263689728', '2a2s26', 24.02000000, '2022-04-01 02:08:27');
INSERT INTO `tb_room_degree` VALUES ('970692241263689728', '2a2s26', 29.02000000, '2022-04-10 02:08:27');
INSERT INTO `tb_room_degree` VALUES ('970692241263689728', '2a2s26', 9.02000000, '2022-05-01 02:08:27');
INSERT INTO `tb_room_degree` VALUES ('970692241263689728', '2a2s26', 9.92200000, '2022-05-10 02:08:27');
INSERT INTO `tb_room_degree` VALUES ('970692241263689728', '2a2s26', 10.33200000, '2022-05-18 02:08:27');
COMMIT;

-- ----------------------------
-- Table structure for tb_setting
-- ----------------------------
DROP TABLE IF EXISTS `tb_setting`;
CREATE TABLE `tb_setting` (
  `setting_id` varchar(255) NOT NULL COMMENT '主键',
  `setting_key` varchar(255) DEFAULT NULL COMMENT '键',
  `setting_value` varchar(255) DEFAULT NULL COMMENT '值',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`setting_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tb_setting
-- ----------------------------
BEGIN;
INSERT INTO `tb_setting` VALUES ('962009891642277888', 'electricity_prices', '0.59', '2022-04-08 15:23:51', '2022-04-08 15:24:23');
COMMIT;

-- ----------------------------
-- Table structure for tb_web_user
-- ----------------------------
DROP TABLE IF EXISTS `tb_web_user`;
CREATE TABLE `tb_web_user` (
  `web_user_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户表主键',
  `account` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT '账户',
  `avatar` varchar(255) DEFAULT NULL COMMENT '用户头像',
  `user_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT '用户名',
  `password` varchar(255) DEFAULT NULL COMMENT '密码',
  `is_admin` int DEFAULT NULL COMMENT '0表示不是，1表示是管理员',
  `phone` varchar(20) DEFAULT NULL COMMENT '手机号码',
  `landline` varchar(20) DEFAULT NULL COMMENT '座机',
  `email` varchar(255) DEFAULT NULL COMMENT '邮箱地址',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `update_time` datetime DEFAULT NULL COMMENT '更新日期',
  `is_deleted` int DEFAULT NULL COMMENT '1表示已删除，0表示正常，2表示禁用',
  `role_id` varchar(255) DEFAULT NULL COMMENT '角色id',
  PRIMARY KEY (`web_user_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='web端用户表';

-- ----------------------------
-- Records of tb_web_user
-- ----------------------------
BEGIN;
INSERT INTO `tb_web_user` VALUES ('898659315928268800', '10000001', 'https://tva1.sinaimg.cn/large/008i3skNgy1gvg886iqt6j60qt0g5jsn02.jpg', 'Admin', '$2a$10$qb1XHJZsPQCnP1NqcLN.jepq9Ky5iwM3wI3VveZIQfwxAHmTdt3Ua', 1, '1367235000', NULL, '1064863952@qq.com', '又三年', '2021-10-15 19:51:17', '2022-03-11 19:00:47', 0, '899080020255834112');
INSERT INTO `tb_web_user` VALUES ('899230764292374528', '100213412', 'https://tva1.sinaimg.cn/large/008i3skNgy1gvg886iqt6j60qt0g5jsn02.jpg', '安装工1', '$2a$10$hW0GnFlt1vtS72tA8ep/Zumo1s8oCN.22C8pj411d6EUYJcqR8phS', 0, NULL, NULL, '1399700611@qq.com', NULL, '2021-10-17 09:42:01', '2021-10-17 09:42:01', 0, '899218474281205760');
INSERT INTO `tb_web_user` VALUES ('947973432358731776', '876913911', 'https://tva1.sinaimg.cn/large/008i3skNgy1gvg886iqt6j60qt0g5jsn02.jpg', '默认用户名', '$2a$10$clETizbTnC9PND3xmQiuQ.54xhoauRNIJB/12yR/D0OnHSpD73bDe', 0, NULL, NULL, '1064863953@qq.com', NULL, '2022-02-28 21:47:59', '2022-03-11 19:04:10', 0, '899218474281205760');
INSERT INTO `tb_web_user` VALUES ('959125484392677376', '516910536', 'https://tva1.sinaimg.cn/large/008i3skNgy1gvg886iqt6j60qt0g5jsn02.jpg', '默认用户名', '$2a$10$bCveRincAfF.KKSkV6LMGOyc7jY2vTnNmlL1Eptw09suh1EiA2jp6', 0, NULL, NULL, '1399700612@qq.com', NULL, '2022-03-31 16:22:15', '2022-03-31 16:22:15', 0, '899218474281205760');
COMMIT;

-- ----------------------------
-- Table structure for tb_web_user_provider
-- ----------------------------
DROP TABLE IF EXISTS `tb_web_user_provider`;
CREATE TABLE `tb_web_user_provider` (
  `id` varchar(200) NOT NULL COMMENT '主键',
  `web_user_id` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT 'web端用户id',
  `provider_id` varchar(200) DEFAULT NULL COMMENT '服务商id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `user_provider_userId` (`web_user_id`),
  KEY `user_provider_providerId` (`provider_id`),
  CONSTRAINT `tb_web_user_provider_ibfk_1` FOREIGN KEY (`provider_id`) REFERENCES `tb_provider` (`provider_id`) ON DELETE CASCADE,
  CONSTRAINT `tb_web_user_provider_ibfk_2` FOREIGN KEY (`web_user_id`) REFERENCES `tb_web_user` (`web_user_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='web端用户所属服务商，组织';

-- ----------------------------
-- Records of tb_web_user_provider
-- ----------------------------
BEGIN;
INSERT INTO `tb_web_user_provider` VALUES ('1', '898659315928268800', '1', '2021-10-16 16:15:37', '2022-03-10 23:41:13');
INSERT INTO `tb_web_user_provider` VALUES ('2', '899230764292374528', '898881404983574528', '2021-10-18 21:17:22', '2021-10-18 21:17:24');
INSERT INTO `tb_web_user_provider` VALUES ('951918475096358912', '947973432358731776', '898881404983574528', '2022-03-11 19:04:10', NULL);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
